Find max value in a row and return column title

G

Guest

Hello.
I would like to find a maximum value across a row of 24 and return the title
I have given that column.
So, if the max value of row R is in cell R20, I would like the function to
return the name in cell A20.
Thanks,
Josh
 
B

Bondi

Jshendel said:
Hello.
I would like to find a maximum value across a row of 24 and return the title
I have given that column.
So, if the max value of row R is in cell R20, I would like the function to
return the name in cell A20.
Thanks,
Josh

Hi Josh,

I'm not sure if this is what you are looking for. But I hope this
works.
This formula will look in ROW 20 and find the largst value in the
column A to X (if more at same value return the first) and return the
contents of ROW 1 in the column where the largst value is encountered.

=INDIRECT(ADDRESS(1,MATCH(MAX(A20:X20),A20:X20,0)))

Regards,
Bondi
 
G

Guest

Well, R would be a column instead of a row, so you want to find the max in
column R, and retrieve the label in column A corresponding to the max value,
right?

=INDEX($A$1:$A$40,MATCH(MAX($R$1:$R$40),$R$1:$R$40,0))
 
G

Guest

Try this:

=INDEX(A:A,MATCH(MAX(R:R),R:R,0))

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 

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