I have the following array formula in cell U22.
=MAX(FREQUENCY(IF('4.6'!F5:'4.6'!F5005>0,ROW('4.6'!F5:'4.6'!F5005),""),
IF('4.6'!F5:'4.6'!F5005*'4.6'!F6:'4.6'!F5005<0,ROW('4.6'!F5:'4.6'!F5005),"")))
This formula counts the longest consecutive entry of positive numbers in sheet
4.6, column F. (Putting *-1 at the end counts for negative numbers.)
What I would like to do in cell U24 is have a formula that counts the most recent
number of consecutive positive numbers.
Example:
1
-4
-3
2
4
7
-1
7
8
The answer would be two. The last two entries 7 & 8 are positive, so we have
two in a row. In other words I'm counting my current positive streak-not my
best streak overall as my inserted formula calculates, which would be three.
Thanks
=MAX(FREQUENCY(IF('4.6'!F5:'4.6'!F5005>0,ROW('4.6'!F5:'4.6'!F5005),""),
IF('4.6'!F5:'4.6'!F5005*'4.6'!F6:'4.6'!F5005<0,ROW('4.6'!F5:'4.6'!F5005),"")))
This formula counts the longest consecutive entry of positive numbers in sheet
4.6, column F. (Putting *-1 at the end counts for negative numbers.)
What I would like to do in cell U24 is have a formula that counts the most recent
number of consecutive positive numbers.
Example:
1
-4
-3
2
4
7
-1
7
8
The answer would be two. The last two entries 7 & 8 are positive, so we have
two in a row. In other words I'm counting my current positive streak-not my
best streak overall as my inserted formula calculates, which would be three.
Thanks
Last edited: