Need a Name value with Max value

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have a formula that gives me a maximum value for a range
ok cells as follows

=MAX(B6:D7,B12:D13,B20:D21,B27:D28,B34:D35)

The problem is that there is a value of Name in the A
column that I would like associated with the max value. I
would like to have that name associate dwith the row that
has the max value.

I would like it to look like below when the formula is run.

Bob 250


Any Suggestions

Thanks

Chris
 
Hi Chris
is there a reason for this non-contigenous range. It would be much
easier if it was a contigenous range. You could use something like
=INDEX(A1:A100,SUMPRODUCT((B6:D35=MAX(B6:D35))*(ROW(B6:D35))))
 
You must log in or register to reply here.

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

Similar Threads

Max Length in a row 1
Locating the max value AND performing a fn on it only 2
MAX value but with two comparison filtering criteria 5
max and calculated cells 1
Formula Cell color limitation 7
MAX across worksheet, return text value 8
Min Value 4
Index of Max Cell 7

Back
Top