Bls: ]] XL-mania [[ Formula Melompat

 

untuk mendapatkan hasil seperti yang diharapkan yang paling pas untuk kasus ini adalah menggunakan formula VLOOKUP formulanya =VLOOKUP($A26;$A$6:$I$8;MATCH(B$25;$A$4:$I$4;0)) copy ke seluruh tabel isian wassalam Ghozi Alkatiri --- Pada Sen, 8/8/11, Limrot <limrot@amtek.com.sg> menulis: Dari: Limrot <limrot@amtek.com.sg> Judul: ]] XL-mania [[ Formula Melompat Kepada: "XL-mania@yahoogroups.com" <XL-mania@yahoogroups.com> Tanggal: Senin, 8 Agustus, 2011, 9:16 AM   Dear Para Pakar XL, Apabila kita copy formula dari kolom B ke colom C, tapi hasil yang kita inginkan ada dikolom D kira2 seperti apa caranya? terlampir contoh yang telah saya buat. rgds Limrot The information contained in this communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by responding to this email and then delete it from your system. We are neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt.

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 63

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| tiap tanggal gajian, order buku "mengapa boss benci chart anda    |
| membludak :) ayo2 pesan yang belum punya....                      |
| btw... selamat menunaikan ibadah puasa ya...                      |
| www.facebook.com/pages/XL-mania/104233892978057                   |
+-------------------------------------------------------------------+
| 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  |
| XL-mania-subscribe@yahoogroups.com 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/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___