Trevor ... Formula works flawlessly (Thanks) ... That said ... Can you take a
moment to give me a step by step (in order) line-item breakdown of how this
formula works? I need to ask T. Valko same thing ... His formula is flawless
too.

Thank you for the guidance ... Kha

"Trevor Shuttleworth" wrote:

One way:

=INDIRECT(ADDRESS(2,MATCH(MAX(B3:P3),B3:P3,0)+1))

If there are multiple maximum values, this will return the name of the first
one.

Regards

Trevor


"Ken" wrote in message
...
Excel2003 ...

Range B2:P2 ... Names
Range B3:P42 ... Values

Looking for Formula in Range Q3:Q42 to return:

Q3 ... "Name" associated with MAX Value found in Range B3:P3
Q4 ... "Name" associated with MAX Value found in Range B4:P4
Q5 ... "Name" associated with MAX Value found in Range B5:P5

Note: also need to know how to handle if multiple "Names" found with same
MAX Value in the Range???

Thanks ... Kha