looking for a solution

[Joe]

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

 

[T. Valko]

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.