Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel formula
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need help figuring out this formula in Excel | Excel Discussion (Misc queries) | |||
Need excel formula to display 28.50hrs in HRS & MINS? | Excel Worksheet Functions | |||
Create a formula in Excel? | Excel Worksheet Functions | |||
Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions | |||
Formula to make Excel count business days/skip weekends? | Excel Worksheet Functions |