PC Review


Reply
Thread Tools Rate Thread

display the name in a list with the maximun salary

 
 
=?Utf-8?B?Y3liZXI=?=
Guest
Posts: n/a
 
      18th Oct 2006
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?
 
Reply With Quote
 
 
 
 
Niek Otten
Guest
Posts: n/a
 
      18th Oct 2006
=INDEX(A1:A50,MATCH(MAX(B1:B50),B1:B50,0))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"cyber" <(E-Mail Removed)> wrote in message news:62DEF18E-879E-4C6D-B6EC-(E-Mail Removed)...
|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?


 
Reply With Quote
 
RadarEye
Guest
Posts: n/a
 
      18th Oct 2006
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
calculate diffence between old salary and new salary Felicia Pickett Microsoft Excel Worksheet Functions 3 6th Apr 2010 04:32 PM
Maximun Memory? =?Utf-8?B?Uy5KLg==?= Windows XP Embedded 1 28th Jan 2006 03:00 PM
rules maximun =?Utf-8?B?TWljb3Jvc2Z0IE91dGxvb2sgUnVsZXMgTWF4aW11 Microsoft Outlook Discussion 1 31st Oct 2005 03:54 PM
maximun rows brendashi@sympatico.ca Microsoft Excel Misc 2 13th Feb 2004 04:36 PM
Maximun record Kenny Microsoft Access 1 7th Aug 2003 07:43 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:41 PM.