I have a sheet which keeps records of football results. I'd like to be able to keep a tally of longest losing streak and longest losing streak.
Column K has the results, either WON or LOST, so I tried to use the SCAN function along with MAX to get the desired result
Here is the formula...