Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
display the name in a list with the maximun salary
I try to display the name in a list with a mximun salary, but the names are
in A1:A50 and salaries in B1:B50. Can I use Vlookup and Max? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
display the name in a list with the maximun salary
=INDEX(A1:A50,MATCH(MAX(B1:B50),B1:B50,0))
-- Kind regards, Niek Otten Microsoft MVP - Excel "cyber" wrote in message ... |I try to display the name in a list with a mximun salary, but the names are | in A1:A50 and salaries in B1:B50. Can I use Vlookup and Max? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
display the name in a list with the maximun salary
Hi Cyber,
I suppose you want the name with the biggest salary: I created my function in the dutch version of Excel giving: =VERSCHUIVING(A1;VERGELIJKEN(MAX(B:B);B:B;0)-1;0) and tried to translate it... =OFFSET(A1,MATCH(MAX(B:B),B:B,0)-1,0) HTH, RaderEye. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate diffence between old salary and new salary | Excel Worksheet Functions | |||
Maximun number of hyperlinks in Excel | Excel Discussion (Misc queries) | |||
width at the hlaf maximun peak | Charts and Charting in Excel | |||
Maximun number of rows and columns | Excel Discussion (Misc queries) | |||
Maximun IF statements in a cell | Excel Programming |