On Mon, 19 Sep 2005 18:55:14 +0100, "Bob Phillips"
wrote:

=INDEX(A20:K20,,MATCH(ROUND(AVERAGE(A21:K21),0),A 21:K21,0))

and

=INDEX(A20:K20,,MATCH(ROUND(AVERAGE(IF(A21:K21<0 ,A21:K21)),0),A21:K21,0))

the second is an array formula, so you need to commit with Ctrl-Shift-Enter
--
HTH

I think there is a problem if the AVERAGE does not appear in A21:K21


--ron