Yes, but I only don't understand how you can use the first formula. As I wrote in #2, for me it returns 0, 1, 0, 0 when entered in H1 and copied down to H4, but as you wrote yourself there are two rows that fulfil the criteria (contain 5 consecutive X.)

[QUOTE]As I wrote in #2, for me it returns 0, 1, 0, 0 when entered in H1 and copied down to H4, but as you wrote yourself there are two rows that fulfil the criteria (contain 5 consecutive X.)[QUOTE]


Oh.. Maybe I accidentally deleted another X in row 3 because the formula should return 0,1,1,0. I'm re attaching the file.

Attached Files

X file.xlsx (14.9 KB, 12 views)