View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default How can i get top 5 salaries in a database

Hi!

Salaries in A1:A100

=LARGE(A$1:A$100,ROWS($1:1))

Copy down to 5 cells

Biff

wrote in message
oups.com...
Any body please help me how to get top 5 salaries from the emp table;