highest number if positive values in a row

[h12]

Hi all!

I have this data set:

Group	Value
1	2
2	3
3	4
4	-9
5	-10
6	3
7	4

And I would like to find out the largest number of positive values in a row. So based on the above, the answer would be 3 (group 1,2,3) as thats the longest streak with positive values. Ofcourse my entire data set is bigger so there will be a range of streaks but I would like to find the longest please.

Many thanks in advance!!

[rzdodson · Accepted solution]

@h12 here is one way to do this:

[ChrisTX · Accepted solution]

Another option attached

 

Chris

[h12]

Thank you both! Exactly what I needed. I was getting stuck on how to identify the streak of positives, but the formula makes sense!