Hi, I'm trying to calculate my longest winning and losing streaks in a game of poker. I have the following example:
A B C
1 Win 1
2 Lose 1
3 Win 1
4 Win 1
5 Win 1
6 Lose 1
7 Lose 1
Longest winning streak = 4
Longest winning streak = 2
I can't figure out how to do addition with calculation reset when results is different from previous. Has anybody done this before?
I tried to do consecutive addition with the formula below, it always gives me a "false". Why?
D3=IF(AND(A3="WIN",A2="WIN"),D2+1,AND(IF(A3<>A2,A2<>"Loss"),1,0))
Bookmarks