=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
|