looking for a solution
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 |
looking for a solution
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 |
All times are GMT +1. The time now is 07:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com