Previous Topic Next Topic

Excel Max Displayed as Row title

Closed
JJ - Sep 16, 2009 at 04:28 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 16, 2009 at 09:25 PM
Hello,
im trying to get the max value for a set of data but displayed as the row's name field.. and not the actual number.

ex.

rock 23432
country 34234
r&b 4232
pop 234
hip pop 1234
genre with the most musicians ______ <- Max formula but displayed as row name, in this case country

any help would be greatly appreciated.

1 reply

Answer 1 / 1
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Sep 16, 2009 at 09:25 PM
if the entries are from A1 to B5
use this formula

=INDEX(A1:A5,MATCH(MAX(B1:B5),B1:B5,0),1)

this will give you
country

modify the formula to suit you.

please see help under "index-match" to understand more about this important function.
0