Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need a pop up solution! | Excel Discussion (Misc queries) | |||
My solution | Excel Discussion (Misc queries) | |||
VLOOKUP - or a better solution | Excel Worksheet Functions | |||
please find a solution | Excel Discussion (Misc queries) | |||
Solution please | Excel Discussion (Misc queries) |