Jawa
sulawesi
irian jaya
kalimantan
#N/A
=INDEX(A$2:A$31,MATCH(0,COUNTIF(I$1:I1,"="&A$2:A$31),0))
=INDEX(A$2:A$31,MATCH(0,COUNTIF(I$1:I2,"="&A$2:A$31),0))
=INDEX(A$2:A$31,MATCH(0,COUNTIF(I$1:I3,"="&A$2:A$31),0))
=INDEX(A$2:A$31,MATCH(0,COUNTIF(I$1:I4,"="&A$2:A$31),0))
=INDEX(A$2:A$31,MATCH(0,COUNTIF(I$1:I5,"="&A$2:A$31),0))
rumus array formula ( [F2] , di formula bar ketik rumus , akhir dgn [Ctrl]
[Shift] bersamaan , jangan dilepas, lalu di akhir [Enter] ) =INDEX(
A$2:A$31,MATCH( 0,COUNTIF(I$1:I1,"="&A$2:A$31),0)) COUNTIF(I$1:I1,"="&A$2:A$31)
==> cari data apa sudah adaMATCH( 0,COUNTIF(I$1:I1,"="&A$2:A$31),0) ==> cari
posisi pada data , dimana nama pulau tak ditemukan INDEX( A$2:A$31,MATCH(
0,COUNTIF(I$1:I1,"="&A$2:A$31),0)) ==> ambil nama pulau tsb pada data
To: belajar-excel@yahoogroups.com
From: niki.dwina...@yahoo.com
Date: Fri, 6 Jan 2012 11:06:40 +0800
Subject: [belajar-excel] Short Listed
Dear B-Excell,
Bagaimana Formula untuk short listed untuk data seperti di attachfile?
Thank's & regard
Niki
=======================================================
Mods Note:
Dgn istilah BARU "Short List" itu, ybs menanyakan
bgmana membuat daftar berisi data unique
(list of Unique Values)
dari suatu daftar yg mengandng data-data kembar.
=======================================================
