Biggest Winner/Loser series

Hello all!

I'm looking for a way to calculate the number of elements in the biggest loser/winner series in a specified column.

So for example, in

---

A1

+1,5%
+4,5%
+2%
-2%
-1,1%
+1,5%
+4,5%
+2%
+8%
+4%
-1%

---

the result I'm looking for would be "5" for the calculated longest winner series, and "2" for the biggest loser series.

Thanks very much in advance,
NF414

Hi NF414, could you share the logic on how you derived 5 and 2?
Also what do you mean by "longest winner series" and "biggest loser series"?



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin