Try this in B15
=IFERROR(INDEX(B$2:B$10,SMALL(IF(B$2:B$10<>"",ROW($A$2:$A$10)-ROW($A$2)+1),ROWS($A$1:A1))),"")
Enter with Ctrl+Shift+Enter
Copy across and down
Try this in B15
=IFERROR(INDEX(B$2:B$10,SMALL(IF(B$2:B$10<>"",ROW($A$2:$A$10)-ROW($A$2)+1),ROWS($A$1:A1))),"")
Enter with Ctrl+Shift+Enter
Copy across and down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks