Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count maximum consecutive positive numbers
In Excel, my challenge is to count the maximum number of consecutive
positive numbers in a column consisting of blank cells and formulas that evaluate to numbers and "". For example, starting in A1, the cells evaluate to: 1 -2 3 5 -6 The result would be 2 (counting the two consecutive positive numbers, 3 and 5, above and below the blank or "" cell). This needs to be done using a single formula or array formula, without using a separate running total column using =MAX, and without using a UDF. They say it can't be done and I need to confirm that. Thank you all, JP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
finding maximum, minimum in a range consists both Positive and Negative numbers | Excel Worksheet Functions | |||
count current run of positive numbers | New Users to Excel | |||
Count cells with positive numbers | Excel Discussion (Misc queries) | |||
how to add consecutive positive numbers | Excel Discussion (Misc queries) | |||
Count Consecutive Numbers in a Row | Excel Worksheet Functions |