Assalamu'alaikum Wr. Wb.

Hai Fiant,

Moga-moga array formula filtering pada file terlampir bisa menjadi
alternatif solusi.
=IFERROR(INDEX(Sheet1!$C$2:$C$9,SMALL(IF(Sheet1!$A$2:$A$9=$A2,ROW(Sheet1!$A$2:$A$9)-1),C$1)),"")

Wassalamu'alaikum Wr. Wb.
Kid.

Attachment: re-Multioutput.xlsx
Description: MS-Excel 2007 spreadsheet

Kirim email ke