Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
The row itself: http://i.imgur.com/5VbTDqs.png
I'm trying to have a formula that will figure out which was my longest win and lose streak (where any value above 0 is considered a win, and any value under 0 is considered a loss), but I can't seem to figure it out whatsoever. I've tried this formula: =MAX(FREQUENCY(IF(I14:I="0",ROW(I14:I)),IF(I14:I <"0",ROW(I14:I)))) But, it doesn't seem to be working whatsoever, I just get an array error. Any help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting current streak | Excel Worksheet Functions | |||
win or lose formula needed | Excel Discussion (Misc queries) | |||
longet Win streak | Excel Worksheet Functions | |||
Winning Streak | Excel Worksheet Functions | |||
Current consecutive streak | Excel Programming |