Hi,
In B18 and copied down & across,
=IFERROR(INDEX(B$3:B$12,SMALL(IF($A$3:$A$12=$E$15, ROW($B$3:$B$12)-ROW($B$3)+1),ROWS(B$18:B18))),"")
Confirmed with CTRL + SHIFT + ENTER
HTH
Hi,
In B18 and copied down & across,
=IFERROR(INDEX(B$3:B$12,SMALL(IF($A$3:$A$12=$E$15, ROW($B$3:$B$12)-ROW($B$3)+1),ROWS(B$18:B18))),"")
Confirmed with CTRL + SHIFT + ENTER
HTH
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
Posting Permissions
Reply With Quote
Bookmarks