Could you post your example again, with the required results included so we can see what you're expecting from the formula.
Not even sure if I'm anywhere close to what you're trying to explain above.
In E1
Formula:
=IF(A1&B1=A2&B2,IFERROR(SEARCH(D1,LOOKUP(A1&B1,A$2:A$31&B$2:B$31,C$2:C$31)),""),0)
In F3
Formula:
=IF(AND(A2&B2=A3&B3,E3<>{"",0}),E3>LOOKUP(1E+100,E$1:E2),"")
In G4, Array confirmed with Shift Ctrl Enter
Formula:
=IF(C4<>"",COUNTIF(INDEX(F$1:F1,MATCH(2,1/LEN(C$1:C1&{""}))):C3,FALSE)=0,"")
First column finds the position of word in D within the relevant string in C.
Second column checks that each word was found after the previous.
Third column returns false if one or more words out of sequence, or true if correct.
What should happen with spelling errors, like the one in C24?
Bookmarks