Thread: [Solved] Comparing 2 columns of Text
View Single Post
 
Old 02-03-2012, 12:19 PM
Berk21 Berk21 is offline Windows XP Office 2010 64bit
Novice
 
Join Date: Jan 2012
Posts: 11
Berk21 is on a distinguished road
Default

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.
Reply With Quote