Kawans, Saya sudah coba2 otak-atik beberapa kali tapi hasilnya tak betul; - =IF(ISNUMBER(SMALL(IF(C7:C11=J7,ROW(1:5)),ROW(1:5))),OFFSET(D6,SMALL(IF(C7:C11=J7,ROW(1:5)),ROW(1:5)),0),""),
hasilnya : kosong - =IF(ISNUMBER(SMALL(IF(C7:C11=G7,ROW(1:5)),ROW(1:5))),OFFSET(D6,SMALL(IF(C7:C11=G7,ROW(1:5)),ROW(1:5)),0),""), hasilnya : hanya bekerja di cell G8 saja - =IF(ISNUMBER(SMALL(IF(C7:C11=G7,ROW(1:5)),ROW(1:5))),OFFSET(D6,SMALL(IF(C7:C11=G7,ROW(1:5)),ROW(1:5)),0),""), hasilnya : hanya bekerja di cell G8 saja - =IF(ISNUMBER(SMALL(IF(C7:C11=G7,ROW(1:5)),ROW(1:5))),OFFSET($D$6,SMALL(IF(C7:C11=G7,ROW(1:5)),ROW(1:5)),0),""), hasilnya : hanya bekerja di cell G8 saja - =IF(ISNUMBER(SMALL(IF(C7:C11=G$7,ROW(1:5)),ROW(1:5))),OFFSET($D$6,SMALL(IF(C7:C11=G$7,ROW(1:5)),ROW(1:5)),0),""), hasilnya : hanya bekerja di cell G8 & G9 saja - =IF(ISNUMBER(SMALL(IF(C$7:C$11=G$7,ROW(1:5)),ROW(1:5))),OFFSET($D$6,SMALL(IF(C$7:C$11=G$7,ROW(1:5)),ROW(1:5)),0),""), hasilnya : hanya bekerja di cell G8 & G9 saja On Tue, Nov 22, 2011 at 6:25 PM, Haps <hapsari.stlizb...@gmail.com> wrote: > ** > > > biasanya begini > > array formula multi hasil > =IF(ISNUMBER(SMALL(IF(C7:C11=J7,ROW(1:5)),ROW(1:5))), > OFFSET(D6,SMALL(IF(C7:C11=J7,ROW(1:5)),ROW(1:5)),0),"") > > > > 2011/11/22 yulian nugroho <yulian...@gmail.com> > >> ** >> >> kawans bantu aku, >> pengin melakukan lookup untuk mendapatkan hasil yang ke-1, ke-2, dst >> coba2 tanpa menggunakan 'helper' tak bisa >> >> terimakasih >> YN >> >> > -- Thanks & Regards Yulian Nugroho
