On Wed, 15 Nov 2006 22:34:22 -0000, "Bob Phillips"
wrote:

Michael,

put the name of the target team in H2, then in H3 add the formula

=IF(AND(D3=H$2,E3G3,MAX(IF(($D$3:$D$40=F3)*($F$3 :$F$40=D3)*($E$3:$E$40<$G$3
:$G$40),1))),F2,"")

which is an array formula, so commit it with Ctrl-Shift-Enter, not just
Enter.

Copy H3 down to H40.

This will list the name of the beaten team in column H in the row where they
are the away team.
I am stuck again, I list of teams which are spread unequally H3:H40. I
trying to list the names in alternate rows in column M. Can you help
again?

Michael.