Thread
:
How can i get top 5 salaries in a database
View Single Post
#
2
Posted to microsoft.public.excel.misc
Biff
Posts: n/a
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;
Reply With Quote