![]() |
|
#10
|
|||
|
|||
|
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. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Pasted text comes in columns
|
yotas312 | Word | 2 | 11-12-2011 07:58 AM |
The text in the two columns are not in the same level!!!! why?
|
Jamal NUMAN | Word | 22 | 10-18-2011 09:00 AM |
Advanced Filter - Comparing Two Columns
|
apolloman | Excel | 5 | 07-27-2011 04:54 AM |
text in columns not even
|
KENDO | Word | 1 | 01-22-2011 01:06 AM |
| macro for comparing data from 3 columns and pasting into another worksheet | ashukla | Excel | 1 | 06-24-2009 05:01 PM |