d1=IFERROR(INDEX(A:A,SMALL(INDEX(($B$1:$B$100="")*10^10+ROW($B$1:$B$100),0),ROWS(D$1:D1))),"")
try this and copy across
d1=IFERROR(INDEX(A:A,SMALL(INDEX(($B$1:$B$100="")*10^10+ROW($B$1:$B$100),0),ROWS(D$1:D1))),"")
try this and copy across
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks