| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting consecutive strings of text
Hi
I want to be able to count how many consecutive numbers are in a column but once there is a break to count the next string in the same column. eg: A Apples Apples Apples Apples Apples NA NA Apples Apples Apples NA ..... So the output that i want is to count the string of Apples (ie: 5) skip the NA then give me a second output of 3. Is this possible? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting consecutive strings of text | Excel Discussion (Misc queries) | |||
| Counting strings of consecutive numbers in a column | Excel Discussion (Misc queries) | |||
| Counting Text Strings | Excel Worksheet Functions | |||
| Counting Text Strings With Conditions | Excel Discussion (Misc queries) | |||
| Counting text strings | Excel Worksheet Functions | |||
Threaded Mode
