Enter array formula in F2 and copy across and down
Formula:
=IFERROR(INDEX($B:$B,SMALL(IF($A$2:$A$22=$E2,ROW($A$2:$A$22)),COLUMNS($F:F))),"")
***Array formula
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
You will know the array is active when you see curly braces { } appear around your formula.
If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Please see attached file
To get list of unique names
Enter in E2 and copy down
Formula:
=IFERROR(INDEX(A$2:A$22,MATCH(0,INDEX(COUNTIF(E$1:E1,A$2:A$22),,),)),"")
Bookmarks