Forum Discussion
Solved
Find a specific list entry and start sequence?
Hi there, I am trying to figure out how to find the match for an input cell in a list, and begin a sequence counting up from this point in said list. See attached screenshot. For example, I have ...
Something like this?
C1 formula: ="F"&FILTER(IF($F$1:$F$46=$B$1,ROW($F$1:$F$46)-MIN(ROW($F$1:$F$46))+1),ISNUMBER(IF($F$1:$F$46=$B$1,ROW($F$1:$F$46)-MIN(ROW($F$1:$F$46))+1)))
D1 formula: ="F"&FILTER(IF($F$1:$F$46=$B$1,ROW($F$1:$F$46)-MIN(ROW($F$1:$F$46))+1),ISNUMBER(IF($F$1:$F$46=$B$1,ROW($F$1:$F$46)-MIN(ROW($F$1:$F$46))+1)))&":"&"F46"
C5:C46 formula: =IF(D5=1,"Start","")
D5:D46 formula: =IFERROR(FILTER(ROW(INDIRECT($C$1):OFFSET(INDIRECT($C$1),$B$2-1,0))-MIN(ROW(INDIRECT($C$1):OFFSET(INDIRECT($C$1),$B$2-1,0)))+1,ISNUMBER(FIND(INDIRECT($C$1):OFFSET(INDIRECT($C$1),$B$2-1,0),F5))),"")
cheers
Something like this?
C1 formula: ="F"&FILTER(IF($F$1:$F$46=$B$1,ROW($F$1:$F$46)-MIN(ROW($F$1:$F$46))+1),ISNUMBER(IF($F$1:$F$46=$B$1,ROW($F$1:$F$46)-MIN(ROW($F$1:$F$46))+1)))
D1 formula: ="F"&FILTER(IF($F$1:$F$46=$B$1,ROW($F$1:$F$46)-MIN(ROW($F$1:$F$46))+1),ISNUMBER(IF($F$1:$F$46=$B$1,ROW($F$1:$F$46)-MIN(ROW($F$1:$F$46))+1)))&":"&"F46"
C5:C46 formula: =IF(D5=1,"Start","")
D5:D46 formula: =IFERROR(FILTER(ROW(INDIRECT($C$1):OFFSET(INDIRECT($C$1),$B$2-1,0))-MIN(ROW(INDIRECT($C$1):OFFSET(INDIRECT($C$1),$B$2-1,0)))+1,ISNUMBER(FIND(INDIRECT($C$1):OFFSET(INDIRECT($C$1),$B$2-1,0),F5))),"")
cheers
Yes! This worked perfectly. Thank you so very much!