Hello,

I have the following data in a column: 7 0 0 0 7 0 0 0 0 0 7 0 0 7 0 0 0 0 0 0 0 7 etc.
The number of zero's between the 7's is random. I want a formula that would count the number of zeros between the 7's.

Thanks,
Ari Bari