Try .. in F4
=IFERROR(INDEX(A$4:A$11,SMALL(IF(COUNTIF($A$4:$A$11,$A$4:$A$11)=1,ROW($A$4:$A$11)-ROW($A$4)+1,""),ROWS($A$4:A4))),"")
Enter with Ctrl+Shift+ENTER
Then copy across and down
Try .. in F4
=IFERROR(INDEX(A$4:A$11,SMALL(IF(COUNTIF($A$4:$A$11,$A$4:$A$11)=1,ROW($A$4:$A$11)-ROW($A$4)+1,""),ROWS($A$4:A4))),"")
Enter with Ctrl+Shift+ENTER
Then copy across and down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks