<*>[Attachment(s) from raya hidayat included below] Dear yth Kinanti.
bila dilihat, keinginan saudara bisa dilakukan dengan menggunakan fungsi vlookup dari excell. cuma kalau melakukan dengan rumus dimana jumlah sampai 10.000 baris maka filenya akan terasa berat. alternatif lain menggunakan macro.. (nah yang ini aku gak pintar, biar master lain yang buatkan) terlampir contoh rumusnya. bila menggunakan vlookup. 2009/4/13 <[email protected]>: > [Attachment(s) from [email protected] included below] > > Dear Xl Mania, > > Tugas Kantor nih, help me please.... > > > > Hanya entry di kolom di “Model”, otomatis kolom “Class”, ”Category” dst …. > terisi. > > Data referensi ada di sheet “Kata Kunci” > > > > Ini sangat2 membantu kami untuk entry data diatas 10,000 baris. Hehehe, kalo > manual bisa keriting semua jari2.... > > > > Regards, > > kinanti > > > > -- Terima kasih Raya <*>Attachment(s) from raya hidayat: <*> 1 of 1 File(s) http://groups.yahoo.com/group/XL-mania/attachments/folder/1386533771/item/list <*> Entry otomatis.xls ------------------------------------ +-:: XL-mania ::::::::::::::::::::----------------------------------+ | Kembali bekerja bersama XL-mania! | | http://www.facebook.com/group.php?gid=37671048001&ref=mf | +-------------------------------------------------------------------+ | DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, | | pembicaraan pribadi, one line message, melecehkan, tidak sopan. | +-------------------------------------------------------------------+ | Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" | | Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. | +-------------------------------------------------------------------+ | Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke | | [email protected] atau kirimkan mereka file dari | | http://groups.yahoo.com/group/XL-mania/files/Promotion/ | +-------------------------------------------------------------------+ | Berikan testimoni di : http://www.friendster.com/xlmania atau... | | http://www.xl-mania.com/2008/06/testimoni-xl-mania.html | +-------------------------------------------------------------------+ | Message lama ada di : | | http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] | | http://www.mail-archive.com/[email protected] | +-------------------------------------------------------------------+Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/XL-mania/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/XL-mania/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/
