Return occurences of similar values from text string

Originally Posted by nflsales

can use ROW(a$1:INDEX(A:A,LEN($A2)-LEN($B$1)+1)) instead of Row(INDEX(A:A,1):INDEX(A:A,LEN($A2)-LEN($B$1)+1))

Thanks for that one, too.