| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
max in on column, description in another
I want to find the highest number in column B and show the name
associated with that number. A B John 123 frank 224 joe 110 frank 224 This would show the name and the associated number. Is there a function that will do this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
max in on column, description in another
In Cell B4 enter
=Max(B1:B3) In cell A4 enter =INDEX(A1:A3,(MATCH(B4,B1:B3,0))) " wrote: I want to find the highest number in column B and show the name associated with that number. A B John 123 frank 224 joe 110 frank 224 This would show the name and the associated number. Is there a function that will do this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
max in on column, description in another
How about combining into a single formula:
=INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "AKphidelt" wrote in message ... In Cell B4 enter =Max(B1:B3) In cell A4 enter =INDEX(A1:A3,(MATCH(B4,B1:B3,0))) " wrote: I want to find the highest number in column B and show the name associated with that number. A B John 123 frank 224 joe 110 frank 224 This would show the name and the associated number. Is there a function that will do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help and description for UDFs | Excel Worksheet Functions | |||
| Select stock code depending on description in next column | Excel Worksheet Functions | |||
| I am trying to abbreviate text in my description column. | Excel Worksheet Functions | |||
| enter item code in one column, automatically get description in ne | Excel Worksheet Functions | |||
| Parameter description | Excel Worksheet Functions | |||
Linear Mode
