Re: ]] XL-mania [[ Look Up Beberapa Karakter di Shhet berbeda

 

Mas Kelana ingin memfilter tetapi tidak terus terang bilang 

bahwa ingin memfilter

Formula filter:  

array formula harus di akhiri dengan menahan nafas PLUS menekan 

3 tombol Terkenal (Ctrl + Shift + Enter):

=IFERROR(INDEX(JURNAL!F$5:F$38,SMALL(IF(JURNAL!$B$5:$B$38=$B$3,ROW($1:$34)),ROW(1:$34))),"")

- i -

2012/1/17 Kelana Putra <k31_l13l@yahoo.com>

Dear Suhu-suhu Excel,

Newbie mo tanya, caranya untuk me lookup beberapa karakter yang berada dilain sheet, sesuai dengan file terlampir.

Sebelumnya sudah coba pke rumus Index dan Match, tapi tetep ga bisa.

Tolong dibantu ya para Suhu-suhu Excel.

Regards,

Kelana

__._,_.___

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

Messages in this topic (2)

Recent Activity:

• New Members 66

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| ayooo... coba cari XL-mania di linkedin.com                       |
| boss2 dari zone visit, moderasi nge-lag lagi deghhhh :(           |
+-------------------------------------------------------------------+
| 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

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

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

.

__,_._,___