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!
Bookmarks