This is fairly complicated...
Here's a small sample file that demonstrates this:
countconsec.xls 16kb
http://cjoint.com/?mnfGX1A8cV
There are 2 formulas used. A2 contains one formula and the other formula is
entered in B2 then copied across to the end of the range.
Press function key F9 to get a different set of numbers in row 1 and you'll
see that this works.
--
Biff
Microsoft Excel MVP
"Joe" wrote in message
...
Hello,
i am looking for help in creating a formula that will allow me to count
consecutive alike numbers such as cells a1=1 b1=1 c1=1 d1=1 e1=0 f1=0
g1=1 h1=0 i1=1 j1=1 k1=1 l1=0 m1=1 n1=1 o1=1 but if it sees a 0 will reset
the count to zero and start again with the first 1 it sees. the above ex
would look something like this in the counting box 4 then 0 then 1 then 0
then 3 then 0 then 3.
thank you