Hello,

In column A, I have a long range with only ones and zeros. There is roughly 19-22 zeros in between every 1.

What I need in column B is: If the value in A(same row) is 1, return 0. For the next row below it should return +1, two rows down +2 and so on until it again finds a 1, and then gives me 0 and repeats.


Doable?