Plan2
A2=IFERROR(INDEX(Plan1!$A$3:$A$12,SMALL(IF(Plan1!$B$3:$AE$12="x",ROW(Plan1!$A$3:$A$12)-ROW(Plan1!$A$3)+1),ROWS(Plan1!$A$3:Plan1!A3))),"")
Control+shift+enter
Copy down
Plan2
A2=IFERROR(INDEX(Plan1!$A$3:$A$12,SMALL(IF(Plan1!$B$3:$AE$12="x",ROW(Plan1!$A$3:$A$12)-ROW(Plan1!$A$3)+1),ROWS(Plan1!$A$3:Plan1!A3))),"")
Control+shift+enter
Copy down
Last edited by CARACALLA; 06-05-2020 at 11:03 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks