Forum Discussion
Solved
Does anyone know a formula to find the longest losing run in the database
Afternoon all, I don’t know if anyone can help me? I have an excel spreadsheet with over 19000 results in a column. I have previously looked down individual systems to find the drawdown, but this...
Hello harwood66,
Assuming a loss equates to negative points and assuming your table starts in A1, then in D3 place the following:
=IF(C3<C2,D2+1,0)
Copy the formula down to the bottom of your list. Next, copy row D (Ctrl + C) and paste values (Ctrl + V, Ctrl, V). Finally, sort column D from largest to smallest. At the top you will see longest losing streak.
Hello harwood66,
Assuming a loss equates to negative points and assuming your table starts in A1, then in D3 place the following:
=IF(C3<C2,D2+1,0)
Copy the formula down to the bottom of your list. Next, copy row D (Ctrl + C) and paste values (Ctrl + V, Ctrl, V). Finally, sort column D from largest to smallest. At the top you will see longest losing streak.
