ExcelBanter - Excel formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel formula (https://www.excelbanter.com/excel-worksheet-functions/11758-excel-formula.html)

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

--
thanks Mike

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Mike" wrote in message
...
I want to find the highest number in a column and display the name in the
column to the left of the highest number

--
thanks Mike

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

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