]] XL-mania [[ Digest Number 2581

Microsoft Excel Community Group

1 New Message

Digest #2581

1a

Re: Mencari Range Nilai berdasarkan Kriteria Tertentu by "Bagus" bagus4bls

Message

1a

Re: Mencari Range Nilai berdasarkan Kriteria Tertentu

Tue Mar 19, 2013 8:45 am (PDT) . Posted by:

"Bagus" bagus4bls

Dear Jimmy;

Coba:
=VLOOKUP(CEILING(D3,5),$A$3:$B$5,2,0)
atau
=INDEX($B$3:$B$5,MATCH(CEILING(D3,5),$A$3:$A$5,0))
atau
=SUMPRODUCT((CEILING(D3,5)=$A$3:$A$5)*$B$3:$B$5)
Copy ke bawah

Wassalam

~ Bagus ~

----- Original Message -----
From: jimmy sihombing
To: XL-mania
Sent: Monday, March 18, 2013 2:23 PM
Subject: ]] XL-mania [[ Mencari Range Nilai berdasarkan Kriteria Tertentu

Hai Master excelmania,

Biasanya jika kita ingin mencari sebuah Nilai berdasarkan kriteria maka bisa menggunakan rumus lookup. Nah! untuk kasus yang satu ini saya kesulitan jika nilai yang dicari berdasarkan kriteria, namun kriterianya berupa range (file terlampir).

Terima kasih atas bantuannya.

Salam,

JHE

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

Visit Your Group

>

View All Topics

>

Create New Topic

>

41 New Members

>

We are making changes based on your feedback, Thank you !

Submit Feedback

>

The Yahoo! Groups Product Blog

Check it out!

>

GROUP FOOTER MESSAGE

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Merry Christmas. May God bless you and your family...             |
+-------------------------------------------------------------------+
| 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.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              |
+-------------------------------------------------------------------+

CHANGE SETTINGS

>

TERMS OF USE

>

UNSUBSCRIBE

>