Thread: Functions
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] dolivastro@gmail.com is offline
external usenet poster
 
Posts: 46
Default 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?