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