Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hey folks! Now you have me learning more and more about Excel, I am trying
to do things I never thought about before! I have a list of game scores, col 'E' TEAM PLAYED Against, col 'F' for opponents and col'G' for Home Team. Col 'H' is either WIN or LOSS based on the scores in two previous columns. What I am trying to do is: of the WINs in col'H' , which game did we do best in (IE: difference in col'G' and col'F' was greatest, and display TEAM name) Of "LOSS" in col'H' which did we do poorest in (IE: difference in col'G' and col'F' was again the greatest) I have tried a few different scenarios but can't seem to find one that works. Thanks again! Duane |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
hardship letter explaining devastating loss property loss financi | Excel Discussion (Misc queries) | |||
10 worst mistakes | New Users to Excel | |||
Best/Worst grade | Excel Worksheet Functions | |||
best and worst outcomes | Excel Worksheet Functions | |||
The worst Code Ever | Excel Discussion (Misc queries) |