LinkBack URL
About LinkBacks
I used this formula in Sheet2:
confirmed with CTRL+SHIFT+ENTER and copied down.
=IFERROR(INDEX(Sheet1!$F$1:$F$31,SMALL(IF(Sheet1!D1:D31="Start",ROW(Sheet1!$D$1:$D$31)-ROW(Sheet1!D1)+1),ROWS($A$2:$A2))),"")
I used this formula in Sheet2:
confirmed with CTRL+SHIFT+ENTER and copied down.=IFERROR(INDEX(Sheet1!$F$1:$F$31,SMALL(IF(Sheet1!D1:D31="Start",ROW(Sheet1!$D$1:$D$31)-ROW(Sheet1!D1)+1),ROWS($A$2:$A2))),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks