Array addressing question... I think


J

John Bennett

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/tutorial...9-082c24acd999/how-to-annotate-images-fr.aspx
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top