Try this:

Enter this formula in Q3 as an array**:

=IF(COLUMNS($A:A)<=COUNTIF($B3:$P3,MAX($B3:$P3)),I NDEX($B$2:$P$2,SMALL(IF($B3:$P3=MAX($B3:$P3),COLUM N($B3:$P3)-MIN(COLUMN($B3:$P3))+1),COLUMNS($A:A))),"")

Copy across to a number of cells that will equal the maximum number of ties
in any of the rows. For example, if there are a max of 3 ties in any single
row then you need to copy the formula across to at least 3 columns. Then
copy down as needed.

** entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER)

Biff

"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

T. ... 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 Trevor same thing ... His formula works fine
too for what it does.

Thank you for the guidance ... Kha

"T. Valko" wrote:

Try this:

Enter this formula in Q3 as an array**:

=IF(COLUMNS($A:A)<=COUNTIF($B3:$P3,MAX($B3:$P3)),I NDEX($B$2:$P$2,SMALL(IF($B3:$P3=MAX($B3:$P3),COLUM N($B3:$P3)-MIN(COLUMN($B3:$P3))+1),COLUMNS($A:A))),"")

Copy across to a number of cells that will equal the maximum number of ties
in any of the rows. For example, if there are a max of 3 ties in any single
row then you need to copy the formula across to at least 3 columns. Then
copy down as needed.

** entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER)

Biff

"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