Michael,

Assuming that you still list the names in H3:H40, then add this to M3

=IF(ISERROR(SMALL(IF($H$3:$H$40<"",ROW($H$3:$H$40 )-MIN(ROW($H$3:$H$40))+1,"
"),ROW($A1:$A40))),"",
INDEX(H$3:H$40,SMALL(IF($H$3:$H$40<"",ROW($H$3:$H $40)-MIN(ROW($H$3:$H$40))+
1,""),ROW($A1:$A40))))

again an array formula, and copy down.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

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