Try these array formulas**.

E2:E11 = team played
F2:F11 = their score
G2:G11 = your score
H2:H11 = W or L

For the team you did the best against (largest difference in score):

=INDEX(E2:E11,MATCH(MAX(IF(H2:H11="W",G2:G11-F2:F11)),IF(H2:H11="W",G2:G11-F2:F11),0))

For the team that really cleaned your clock <g:

=INDEX(E2:E11,MATCH(MIN(IF(H2:H11="L",G2:G11-F2:F11)),IF(H2:H11="L",G2:G11-F2:F11),0))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"Duane" wrote in message
...
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