M
Mike
Good Morning All,
Using Excel XP.
I have a worksheet that keeps track of every baseball game that a team
plays. In one of the columns I have a title called "streak", which gives
the current winning or losing streak. Here's a sample:
A B
W/L Streak
---------------------------------
1 W W-1
2 W W-2
3 L L-1
4 W W-1
5 L L-1
6 L L-2
7 L L-3
8 L L-4
9 W W-1
10 W W-2
Is it possible to make a formula that would automatically count the winning
streak as shown in Column B?
Thanks for your help in advance,
Mike
Using Excel XP.
I have a worksheet that keeps track of every baseball game that a team
plays. In one of the columns I have a title called "streak", which gives
the current winning or losing streak. Here's a sample:
A B
W/L Streak
---------------------------------
1 W W-1
2 W W-2
3 L L-1
4 W W-1
5 L L-1
6 L L-2
7 L L-3
8 L L-4
9 W W-1
10 W W-2
Is it possible to make a formula that would automatically count the winning
streak as shown in Column B?
Thanks for your help in advance,
Mike