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
--
AriBari
------------------------------------------------------------------------
AriBari's Profile:
http://www.excelforum.com/member.php...o&userid=25043
View this thread:
http://www.excelforum.com/showthread...hreadid=388069