3 |
=IFERROR(INDEX($B$3:$B$15,AGGREGATE(15,6,ROW($B$3:$B$15)-ROW($B$3)+1/(LEN($A$3:$A$15)=1),ROWS($1:1))),"") |
=IFERROR(INDEX($B$3:$B$15,AGGREGATE(15,6,ROW($B$3:$B$15)-ROW($B$3)+1/(LEN($A$3:$A$15)=3),ROWS($1:1))),"") |
=IFERROR(INDEX($B$3:$B$15,AGGREGATE(15,6,ROW($B$3:$B$15)-ROW($B$3)+1/(LEN($A$3:$A$15)=5),ROWS($1:1))),"") |
=IFERROR(INDEX($B$3:$B$15,AGGREGATE(15,6,ROW($B$3:$B$15)-ROW($B$3)+1/(LEN($A$3:$A$15)=7),ROWS($1:1))),"") |
=IFERROR(INDEX($B$3:$B$15,AGGREGATE(15,6,ROW($B$3:$B$15)-ROW($B$3)+1/(LEN($A$3:$A$15)=9),ROWS($1:1))),"") |
Bookmarks