alternatif selain OFFSET
=INDEX($A$3:$A$8,MATCH(,COUNTIF(D$2:D2,$A$3:$A$8),0)) -zam- <http://wongmbatu.blogspot.com/> http://wongmbatu.blogspot.com/ _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Sukarno Sent: Monday, August 04, 2008 8:55 AM To: [email protected] Subject: ]] XL-mania [[ LOUV untuk type data Numeric & String Dear XL Master Saya mencoba membuat LOUV dari data disamping kiri, tetapi kenapa type data yg bukan numeric (string) ga bisa diambil ya? Apa ada yg salah dengan formulanya: {=OFFSET($A$2,MATCH(SUM(COUNTIF($A$3:$A$8,$D$2:D2)),COUNTIF($A$3:$A$8,"<"&$A $3:$A$8),0),0)} Mohon pencerahan dari para XL Master ITEM CODE DESCRIPTION LOUV 404101002 Camera Color 404101002 404101002 Camera Color 404101003 404101002 Camera Color #N/A 3-1-06-32 Hose 1 #N/A 3-1-06-40 Hose 2 #N/A 404101003 Camera B/W #N/A Best Sukarno
