| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Functions
I need to display the name in a list with the maximun salary. What function
I need? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Functions
I assume that the salaries appear in the range A1:A15, and the names
appear in B1:B15. Then use this: =VLOOKUP(MAX(A1:A15), A1:B15,2) Hope this helps, Dom cyber wrote: I need to display the name in a list with the maximun salary. What function I need? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Functions
=VLOOKUP(MAX($A$1:$A$19),$A$1:$B$19,2,FALSE)
You will have to ensure that the salaries are to the left of the names. A1:A19 is the list of salaries HTH Thanks, Simon cyber wrote: I need to display the name in a list with the maximun salary. What function I need? -- -------------------- Simon - UK Email at simon22mports [ a t ] hot mail [ d ot ]com Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
| Conversion from Spreadsheet Toolkit functions (ESSV....) to EssBase API functions | Excel Programming | |||
| Nesting functions in the functions dialog box | Excel Worksheet Functions | |||
| excel functions and User defined functions | Excel Programming | |||
Linear Mode
