Re: ]] XL-mania [[ cari data dengan baris acak

 

formula yg agak pendek, array formula

 

=INDEX($E$4:$E$21,MAX(($B$4:$D$21=I15)*(ROW($1:$18))))

 

syaratnya sekelompok "Data A" itu harus unique

 

---

----- 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

Data A			Data B		Dicari	Hasil
7	6	47	qw		24	lz
9	8	59	er		19	df
11	10	71	ty		119	df
13	12	83	ui		15	op
15	14	95	op
17	16	107	as
19	18	119	df
21	20	131	gh
23	22	143	jk
25	24	155	lz
27	26	167	xc
29	28	179	vb
31	30	191	nm
33	32	203	ad
35	34	215	gj
37	36	227	wr
39	38	239	yi
41	40	251	xv

__._,_.___

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

Messages in this topic (2)

Recent Activity:

• New Members 81

Visit Your Group

+-:: 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              |
+-------------------------------------------------------------------+

MARKETPLACE

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

---

Welcome to Mom Connection! Share stories, news and more with moms like you.

---

Hobbies & Activities Zone: Find others who share your passions! Explore new interests.

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

.

__,_._,___