Unable to create a simple win / loss chart

hey guys, I have a # of games played column (Column A), a # of games won column (Column B), and a number of games lost column (Column C)

I'm trying to make it so Column C automatically enters the number when I put in the number in Column B.

Example:

Games Played........Win........Loss
1.........................1...........0
2.........................1...........1
3.........................1...........2
4.........................2...........2

For the fifth game played, if I won it, how do i make the 2 to automatically enter into the loss column when I put in the number 3 in the win column?

hi Celltech, welcome to the forum. so there are no draws? C2 can be:
=A2-B2
drag down the formula then highlight your current range (i presume it's A1:C5) & press CTRL + T to convert it to a Table. as you type in the next row, it'll capture the formula too

Right click the sheet tab and select view code and copy and paste the below code in the VBA code window. Return to excel and check

Code solution

Please Login or Register  to view this content.