| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Countif to Count Consecutive Relative Increases in Numbers
Col A through D contain the data. Col E contains the formula I'm asking
about: Col A Col B Col C Col D Col E 7 6 7 2 1 4 3 2 1 4 8 10 9 8 - 5 3 2 10 3 I'd like to Col E to count consecutive improvements for each row of data starting in Col A relative to Col B, then Col B relative to Col C. Is there a way to do this? Thanks a lot! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| How do I add consecutive numbers but start over at break in the. | Excel Discussion (Misc queries) | |||
| How do I add consecutive numbers but start over at a break in the. | Excel Discussion (Misc queries) | |||
| How do I add consecutive numbers but start over at a break in the. | Excel Discussion (Misc queries) | |||
Threaded Mode
