Ada !!!
formula biasa
=INDEX($E$4:$E$21,
MATCH(I15,OFFSET($B$4:$B$21,0,
1*(COUNTIF($B$4:$B$21,I15)>0)+
2*(COUNTIF($C$4:$C$21,I15)>0)+
3*(COUNTIF($D$4:$D$21,I15)>0)-1,,1),0))
kepanjangan yak...
----- Original Message -----
From: ADE ILHAM
To: XL MANIA
Sent: Monday, April 19, 2010 1:41 PM
Subject: ]] XL-mania [[ cari data dengan baris acak
Dear Rekan2 xl-mania
mohon bantuannya lagi, saya ada kasus.
=INDEX($E$4:
MATCH(I15,OFFSET(
1*(COUNTIF($
2*(COUNTIF($
3*(COUNTIF($
kepanjangan yak...
----- Original Message -----
From: ADE ILHAM
To: XL MANIA
Sent: Monday, April 19, 2010 1:41 PM
Subject: ]] XL-mania [[ cari data dengan baris acak
Dear Rekan2 xl-mania
mohon bantuannya lagi, saya ada kasus.
Ada gk yang tau cara untuk mendapat hasil sesuai tabel dibawah (file juga terlampir).
Thanksya udh ngeluangin waktu buat bantu
Kindly Regards
Ade ilham
Thanksya udh ngeluangin waktu buat bantu
Kindly Regards
Ade ilham
__._,_.___
+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Horeeee... tembus 14,000 members... |
| 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 |
| 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 |
+-------------------------------------------------------------------+
| Horeeee... tembus 14,000 members... |
| 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 |
| 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 |
+-------------------------------------------------------------------+
MARKETPLACE
.
__,_._,___
Nenhum comentário:
Postar um comentário