yang harus diisi dulu formula di kolom H3 (formula array)
=SUBSTITUTE(SMALL(IFERROR(--SUBSTITUTE($C$4:$E$8,"-","0000"),""),ROW(1:1)),"0000","-")
copy ke bawah.
baru berikutnya formula di kolom G karena harus merujuk ke kolom H
formulanya =INDEX(B:B,SUMPRODUCT((C$4:E$8=H3)*ROW($C$4:$E$8)))

copy ke bawah
wassalam 
Ghozi Alkatiri

Attachment: ghozi re contoh_PCL.xlsx
Description: MS-Excel 2007 spreadsheet

Kirim email ke