Hi - With the help of this forum, I was able to determine the longest streak for Wins and Losses. But I'm trying to have a running count of Win/Loss streaks, while ignoring Ties for the following set of data (also attached):
A B
1 W
2 L
3 W
4 W
5 T
6 T
7 W
8 W
9 T
10 L
11 L
12 T
13 T
14 W
15 W
Column A1:A15 represents Win, Loss, or Tie.
I'm having a hard time figuring out on how to show in column B the current Winning and Lossing streaks. The catch is that Ties are ignored and streak is the same as previous W/L streak. So column B should show:
A B
1 W 1
2 L 1
3 W 1
4 W 2
5 T 2
6 T 2
7 W 3
8 W 4
9 T 4
10 L 1
11 L 2
12 T 2
13 T 2
14 W 1
15 W 2
I have the following formulas:
B1: = IF(A1="T",0,1)
B2: = IF(A2=A1,B1+1,(IF(A2="T",B1,1)))
B3: = IF(A3=A2,B2+1,(IF(A3="T",B2,1)))
B4:B15: formula copied from above cell....
It works if I just have one T follows by a W or L. It doesn't work when I have a streak of T's. Can someone help? Thanks.
Bookmarks