Hi, I've been searching for an answer to this for a while but can't work it out, so I'm calling for help!
(BTW, I'm using Google Sheets)
I've a list of football results, and I'm trying to calculate the longest unbeaten run. Column A shows the result (Won, Lost, Drawn). I'd like column B to increase by 1, for every row until a "Lost" is reached. The "Lost" resets the counter to 0.
Here is an example of what the outcome should be.
<tbody>
</tbody>
Thank you so much in advance!
(BTW, I'm using Google Sheets)
I've a list of football results, and I'm trying to calculate the longest unbeaten run. Column A shows the result (Won, Lost, Drawn). I'd like column B to increase by 1, for every row until a "Lost" is reached. The "Lost" resets the counter to 0.
Here is an example of what the outcome should be.
A | B |
Won | 1 |
Won | 2 |
Drawn | 3 |
Drawn | 4 |
Lost | 0 |
Lost | 0 |
Won | 1 |
Lost | 0 |
Won | 1 |
Drawn | 2 |
<tbody>
</tbody>
Thank you so much in advance!