Array addressing question... I think
 

Hi,

I have a problem I can't seem to solve.

Columns B through G contain data.
Row 4 contains a name.
Other rows contain numerical data.

I'm trying to figure out how to create a formula in Row H that shows the value in Row 4 for the maximum of the row.

For example, if B4 = Fred, C4 = Joe, D4 = Sally, and
if B5 = 1, C5 = 8, and D5 = 36, then
H5 would be "Sally".

Any ideas?


Submitted via EggHeadCafe - Software Developer Portal of Choice
How to Annotate Images from a database in a web page
http://www.eggheadcafe.com/tutorials...images-fr.aspx

Array addressing question... I think
 

Try

=INDEX($B$4:$G$4,MATCH(MAX($B5:$G5),$B5:$G5,0))

HTH

Bob


<John Bennett wrote in message ...
Hi,

I have a problem I can't seem to solve.

Columns B through G contain data.
Row 4 contains a name.
Other rows contain numerical data.

I'm trying to figure out how to create a formula in Row H that shows the
value in Row 4 for the maximum of the row.

For example, if B4 = Fred, C4 = Joe, D4 = Sally, and
if B5 = 1, C5 = 8, and D5 = 36, then
H5 would be "Sally".

Any ideas?


Submitted via EggHeadCafe - Software Developer Portal of Choice
How to Annotate Images from a database in a web page
http://www.eggheadcafe.com/tutorials...images-fr.aspx