Please, I would like to have a formula to calculate how many times the group of words in D1: D3 appears, in that order, in the range A1: A20.
The formula should return 4.
Thanks in advance.
<tbody>
A
D
cat
cat
dog
dog
turtle
turtle
aaa
kkk
cat
dog
turtle...