Post a cell to the left of a Max/Large number

[swhiak]

My brain is melting right now. I have been trying to work out this situation for a while and I can not figure it out. I want to bring up a cell to the left of a min max. Here is an example of what I am trying to do.

Dog 434 Cat 203 Bird 65 Fish 192

What I want is to be able to run a Max and then a Large to pull up the cell to the left of the two highest values. So after I run the formula it will bring up Dog and then Cat on the second.

Thank you for any and all help!

[ChemistB]

If your data is in row 1

=INDEX($A$1:$H$1,MATCH(MAX($A$1:$H$1),$A$1:$H$1,0))
does that work for you?

[tigeravatar]

@ChemistB, doesn't that formula just return the max number? So in user's posted example, it would return 434 when he needs it to return Dog. So I imagine the Index range should be $A$1:$G$1 while the Match range should be $B$1:$H$1

[Haseeb Avarakkan]

Or,

Just -1 from the MATCH,

=INDEX($A$1:$H$1,MATCH(MAX($A$1:$H$1),$A$1:$H$1,0)-1)

[ChemistB]

Tiger, yep, good catch. Thanks