[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.
|