ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to gt Top N records/Top N Groups (https://www.excelbanter.com/excel-discussion-misc-queries/134000-how-gt-top-n-records-top-n-groups.html)

Pat Dools

How to gt Top N records/Top N Groups
 
Hello,

If I have a large # of salesperson records in which each record includes
Sales Person name and Sales, how can I filter my worksheet to show only the
Top 5 Sales records? Also, if I have grouped my records by Sales Person,
how do I obtain the Top 5 Sales Persons' by Total Sales?

Thanks.
--
Pat Dools


All times are GMT +1. The time now is 11:22 PM.

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