hi
I have a sheet which records win and losses. Here's my dilemma:-
Column I displays the results, so it has either Win or Lost.
Column A has the sequence number.
The idea is that sequences restart after 4 Win or 1 Lost. The number would be like this
1 Win
1 Win
1 Win
1 Win
2 Win
2 Lost
3 Lost
4 Win
4 Win
4 Win
4 Win
5 Lost
6 Lost
7 Win
7 Win
7 Lost
8 Win
And so on. So you see that each sequence has the next number and a sequence starts after either 4 showing as Win or 1 showing as Lost
Any thoughts on how to best approach this one? I looked at the SEQUENCE function, but wasn't able to get that to behave as I wanted.
I have tried using =COUNTIF($I$1:I1,I4) but that was not helping. I thought to try and compare existing row to the previous, but of course, where there are more than 2 occurrences of Lost, it would count them as a sequence, rather than restarting the numbering
Thanks in advance
Bookmarks