Running Win-Lost Record

[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

 

[Gord Dibben]

Mike

Have a look at the thread of your earlier post on the same subject.

http://snipurl.com/dz0c


Gord Dibben Excel MVP

 

[Trevor Shuttleworth]

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

 

[Harlan Grove]

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

....

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"))

 

[Jim]

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