| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting the largest number of consecutive 1's in a column
Hello, I have a column with 1000+ rows, each row having a 0 or 1. I'm
looking for a formula that will give me the highest number of consecutive 1's in the entire column. Just in case I didn't explain this correctly, here is an example with a column fragment laid sideways: 0101100001111000111110010101. In this example the formula was produce a result of 5. I'm not sure if this is possible. Thanks for your help, David |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup function/sum function | Excel Discussion (Misc queries) | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Counting number of consecutive zeros at the end of a list | Excel Discussion (Misc queries) | |||
| find the largest number in column | Excel Discussion (Misc queries) | |||
Threaded Mode
