Array addressing question... I think


John Bennett


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


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