Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Count the number of times 1 happened in a row
Hi Everyone. I'm trying to figure out how to do a formula for the number of
times 1 happened in a row starting from a certain date. For example, from A1 I have 1,1,1,0,0,1,1,1,1,0,0 - I would like to get the answer of 3 (as starting from A1 I have 3 "1s" in a row, the rest of the numbers aren't relevant). The max I want to be able to get is 11. -- Thanks! Stephen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I count the number of times a particular charcter ("." say) | Excel Discussion (Misc queries) | |||
Number of times a number is shown | Excel Worksheet Functions | |||
How do I count the times a number occurs in a given criteria? | Excel Discussion (Misc queries) | |||
Count number to reach a cumulative value | Excel Worksheet Functions | |||
Count number of shaded cells | Excel Discussion (Misc queries) |