Excel formula

Mike · Feb 5, 2005

I want to find the highest number in a column and display the name in the
column to the left of the highest number

Ken Wright · Feb 5, 2005

=INDEX(A1:A30,MATCH(MAX(B1:B30),B1:B30,0))

Aladin Akyurek · Feb 5, 2005

Since it cannot be excluded that there can be many names having the same
max value, try the approach I describe in:

http://tinyurl.com/64mz3