Dear all,
Need help. Please refer the attachment.
Thanks
i refer this formula, but can't work
=IFERROR(IF(OR($J$5:$J$13=$I$14),IFERROR(INDEX(I$5:I$13,SMALL(IF($J$5:$J$13=$I$14,ROW($J$5:$J$13)-ROW($J$5)+1),ROWS(I$17:I17))),""),INDEX(I$5:I$13,SMALL(ROW($J$5:$J$13)-ROW($J$5)+1,ROWS(I$17:I17)))),"")
Bookmarks