2nd option was more of what i was looking for...comparing wins to loss and placing the one in the column that was greater...perfect..
Can another column be added?
This would be the part where i would be comparing another game.
To clarify why im using this to count wins vs. loss...the games are best of 5..
(out of 5 games, who took more wins or losses= team win or a team loss) your formula works great so far..
Im going to expand the criteria.
taking what you gave me and adding another column to add(+)to the results.
Example:"my"team beat teamX 4:1...the next time we played, TeamX happened to win 3:2. "my team" total wins= 1 loss =1 against that team.
once i can do that, i can add in the other teams in, and be able to show My teams wins,losses to all the teams we played against for a season...
You have been great..thanks so much for helping me out.
|