Excel Max Displayed as Row titleClosed

Question

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.

venkat1926 · Answer

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.

Excel Max Displayed as Row title

1 response

Similar discussions

Subscribe To Our Newsletter!