Running Win-Lost Record

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hello All,

Using Excel XP.

In a worksheet Column A is whether a team won or lost a game with a W or an
L.
In column B I would like to have the running win and lost record, for
example:

A B
------------------------------
1 W 1-0
2 W 2-0
3 L 2-1
4 W 3-1
5 L 3-2
6 L 3-3
7 L 3-4

I would like to have a formula in Column B to compute the W-L record after
entering the data in column A.
Thank you in advance.

Mike
 
Mike

in cell B1, put the formula:

=COUNTIF($A$1:A1,"W") & "-" & COUNTIF($A$1:A1,"L")

Drag down as far as needed

Regards

Trevor
 
Mike wrote...
....
In a worksheet Column A is whether a team won or lost a game with a W or an
L.
In column B I would like to have the running win and lost record, for
example:

W 1-0
W 2-0
L 2-1
W 3-1
L 3-2
L 3-3
L 3-4
Click to expand...
....

B1 you should be able to figure out yourself.

B2:
=IF(A2="","",(LEFT(B1,FIND("-",B1)-1)+(A2="W"))&"-"
&(MID(B1,FIND("-",B1)+1,6)+(A2="L")))

Fill B2 down as needed. An alternative,

B1:
=IF(A1="","",COUNTIF(A$1:A1,"W")&"-"&COUNTIF(A$1:A1,"L"))
 
Mike said:
Hello All,

Using Excel XP.

In a worksheet Column A is whether a team won or lost a game with a W or an
L.
In column B I would like to have the running win and lost record, for
example:

A B
------------------------------
1 W 1-0
2 W 2-0
3 L 2-1
4 W 3-1
5 L 3-2
6 L 3-3
7 L 3-4

I would like to have a formula in Column B to compute the W-L record after
entering the data in column A.
Thank you in advance.

Mike
Click to expand...
 
Back
Top