Bls: ]] XL-mania [[ Sortir dan Lanjut Baris Otomatis

 

Silakan Dicoba...

Formula Array Untuk ID

{=INDEX(A4:B25;SMALL(IF(C4:C25=G17;ROW(1:22));ROW(1:22));1)}

Formula Untuk Array LEVEL

{INDEX(A4:B25;SMALL(IF(C4:C25=G17;ROW(1:22));ROW(1:22));2)}

Salam

d4nk

---

Dari: Irfano Miner <fano.theminer@yahoo.co.id>
Kepada: "XL-mania@yahoogroups.com" <XL-mania@yahoogroups.com>
Dikirim: Rabu, 11 Mei 2011 11:17
Judul: ]] XL-mania [[ Sortir dan Lanjut Baris Otomatis

 

Dear All Master Excell

Saya ingin bertanya. Mohon Bantuannya. :D
Formula seperti apa yang bisa mem-filter kolom, sekaligus secara otomatis berlanjut pada baris berikutnya?

Lebih jelasnya pada attachment.

Tks sebelumnya.

 

DATA					SORTIR : Containing A				SORTIR : Containing B
ID	LEVEL	CONTAIN			ID	LEVEL	CONTAIN		ID	LEVEL	CONTAIN
Id_1	1	A			Id_1	1	A		Id_1	4	B
Id_1	2	A			Id_1	2	A		Id_1	5	B
Id_1	3	A			Id_1	3	A		Id_1	6	B
Id_1	4	B			Id_1	8	A		Id_1	7	B
Id_1	5	B			Id_1	9	A		Id_2	3	B
Id_1	6	B			Id_1	10	A		Id_2	4	B
Id_1	7	B			Id_2	1	A		Id_2	5	B
Id_1	8	A			Id_2	2	A		Id_3	2	B
Id_1	9	A			Id_2	6	A		Id_3	3	B
Id_1	10	A			Id_3	1	A		Id_3	4	B
Id_2	1	A			Id_3	5	A		Id_3	6	B
Id_2	2	A
Id_2	3	B
Id_2	4	B
Id_2	5	B
Id_2	6	A
Id_3	1	A
Id_3	2	B
Id_3	3	B
Id_3	4	B
Id_3	5	A
Id_3	6	B

 

__._,_.___

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

Messages in this topic (4)

Recent Activity:

• New Members 100

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| maaf baru moderate sekarang... momods kurang tidur berhari-hari   |
| jadi budak kantoooOOooorrr...                                     |
| 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

Find useful articles and helpful tips on living with Fibromyalgia. Visit the Fibromyalgia Zone today!

---

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

.

__,_._,___