Pakai Data Validation kemudian digabung sama Vlookup. Buat Listnya dulu, missal :
Toyota Kijang 150.000,- Escudo Nomade 90.000,- SideKick Drag one 80.000,- Pada isian, Klik Data Validation, pilih List, sourcenya ambil table di atas. Pada kolom sampingnya, buat formula vlookup. Jadi deh ... Salam, Agus S. _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Sofyan Sent: Jul 08, 2008 12:07 PM To: [email protected] Subject: Re: [ITCENTER] tanya soal excel Semacam auto filter bukan..mas agus, coba deh gunakan yang Advance filter nya, Data - filter - Advance Filter- Isikan range area Dan criteria area yang ingin di tampilkan.. Smoga membantu.... -------Original Message------- From: Agus Haryo Suprojo Date: 7/7/2008 11:51:09 AM To: [EMAIL PROTECTED] <mailto:itcenter%40yahoogroups.com> s.com Subject: [ITCENTER] tanya soal excel Dear All, Gmana carae membuat auto field pada exel berdasarkan kumpulan data yg ada, jika kata input data maka data yang cocok akan tampil secara otomatis Thanks... Internal Virus Database is out of date. Checked by AVG. Version: 8.0.100 / Virus Database: 269.23.16/1445 - Release Date: 15-May-08 7:25 PM ----------------------------------------------------------- Notification: As of 27 Mar 2007, PT. Kiani Kertas had changed its name to PT. Kertas Nusantara. In conjunction with the name change, the email address' domain had also changed from @site.kiani.com to @site.kertas-nusantara.com. [Non-text portions of this message have been removed] ------------------------------------ -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ITCENTER/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
