Functions
 

I need to display the name in a list with the maximun salary. What function
I need?

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?

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