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.