Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula to track wins/loses
In match set of five games I want to keep track of the
wins and loses of the matches. Example; if the number entered in cell b5 is greater than the number entered in b6 then a 1 (for one win) is entered in cell v5. If not, then a 1 (for one lose) is entered in cell v6. This scenerio would be repeated in ajoining cells as the matches progress. I.e., next match would be entered in b6 & c6, b7 & c7, etc. The numbers in cells v5 & v6 are cummulative. So, if a person won 4 matches with scores of 3/2, 4/1, 3/2, 3/2 and lost 3 matches with scores of 2/3, 1/4, and 2/3, in cells v5 and v6 it would show 4 wins and 3 loses. Thanks |
#2
|
|||
|
|||
Glad it worked, Wally !
Thanks for feedback -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "wally" wrote in message ... It works great, thanks alot Wally |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display answer only in another cell of one containing a formula | Excel Discussion (Misc queries) | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
Formula displays does not calculate | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) |