Assume A5:A20 is the data, try this:
B5 = A5+B4 (copy formula down)
Now make a table with 2 columns. First column will be 7, 14, 21, 28,
35, etc. and second column will be:
COUNTIF(B5:B20,<First column)-1
Hope this helps.
AriBari Wrote:
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
--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile:
http://www.excelforum.com/member.php...fo&userid=7094
View this thread:
http://www.excelforum.com/showthread...hreadid=388069