Hi everyone,


I need to understand the index of the column when the first (second, third) consecutive occurence of a number takes place. For example,


1 1 0 0 0 0 0 1 1 0 0 0


we have 2 cases of 2 consecutive occurences of number 1. The first one starts in the 1st column, the second - in the 8th column. I would need a formula that would return 1 and 8 (in separate cells).


Similarly, in case


2 1 1 1 2 3 1 1 0 0 0 0


we have 1 case of 3 consecutive occurences of number 1, which starts in the 2nd column. In this case the formula should return 2.


Could anyone help to solve this problem?


Thanks a lot in advance!