Hi Ron,

Do you know of a workaround should the situation arise?

Ron Rosenfeld wrote:
=INDEX(A20:K20,,MATCH(ROUND(AVERAGE(A21:K21),0), A21:K21,0))

[quoted text clipped - 3 lines]

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

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

Cheers,
Sam

Ron Rosenfeld wrote:
=INDEX(A20:K20,,MATCH(ROUND(AVERAGE(A21:K21),0), A21:K21,0))

[quoted text clipped - 3 lines]

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

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

--ron


--
Message posted via http://www.officekb.com