ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can i get top 5 salaries in a database (https://www.excelbanter.com/excel-discussion-misc-queries/72516-how-can-i-get-top-5-salaries-database.html)

[email protected]

How can i get top 5 salaries in a database
 
Any body please help me how to get top 5 salaries from the emp table;


Biff

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;





All times are GMT +1. The time now is 02:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com