View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] c2hda1@gmail.com is offline
external usenet poster
 
Posts: 1
Default Formula for Win/Lose Streak

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.