Excel Max Displayed as Row title

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
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.