| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Consecutive Values
Is there a way to count consecutive values in a column? Preferably I'd prefer
to only count strings that are at least 5 values long. For Example: Column A Column B JETS JETS JETS JETS JETS JETS 6 CARS CARS CARS CARS JETS CARS JETS In this example Column A is my data values, and Column B is "helper" column that counts a consecutive string and identifies it at the end of the string (A6 is the end of the JETS run, so B6 identifies the string as 6 values long). Any help would be appreciated. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
| Count & Sum Consecutive (2x) appearance of Specific Numeric Values | Excel Worksheet Functions | |||
| Return Summed Count of Multiple Consecutive Numeric Values | Excel Worksheet Functions | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count consecutive repeted values | Excel Discussion (Misc queries) | |||
Threaded Mode
