LinkBack URL
About LinkBacks
Poss273 
Try
A2Formula:
=IFERROR(INDEX(Sheet1!$A$2:$A$4,SMALL(INDEX((Sheet1!B$2:B$4<>"x")*10^10+ROW(Sheet1!$B$2:$B$4)-ROW(Sheet1!$B$2)+1,),ROWS(A$1:A1))),"")
copy across
Try
A2Formula:=IFERROR(INDEX(Sheet1!$A$2:$A$4,SMALL(INDEX((Sheet1!B$2:B$4<>"x")*10^10+ROW(Sheet1!$B$2:$B$4)-ROW(Sheet1!$B$2)+1,),ROWS(A$1:A1))),"")
copy across
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks