Ok here's what I got:

A. I have cells: D40, G40, J40, M40, P40, S40, V40, Y40, AB40, AE40,
which have varius numbers in them.

B. I have cells: D34, G34, J34, M34, P34, S34, V34, Y34, AB34, AE34,
which have varius names in them.

In cell G53 I need a formula that finds the MAX for D40, G40, M40 and
so on

Let's say the max is 3, then search cells D34, G34, J34 and so on and
if that cell has a 3 display the name. This is the formula I have:

=INDEX($D$34:$AS$34,MATCH(MAX(D40:AS40),D40:AS40,0 ))

Only problem is if there are multiple answers, it only displays the
first cell that is true. In my formula D34, M34 and S34 all equal 3,
but cell G53 just shows D34. Can someone help?

Thanks


--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986
View this thread: http://www.excelforum.com/showthread...hreadid=540574