| 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) | |||
Threaded Mode
