Max problems

[JasonCrow]

here is the two columns i have

john 23
mark 12
tom 56
Jim 6

i want to figure out how to display the name with the max number, i know a simply max formula will show which number is highest, but what formula will show the name that corresponds to that highest number?

Thanks, Jason Crow

[Palmetto]

Assuming Column-A = Names and Column-B = numeric values:

=INDEX($A$1:A4,MATCH(MAX($B$1:B4),$B$1:B4,0),1)

Adjust range references as needed.

[JasonCrow]

Thankyou so much! It works Great