How to gt Top N records/Top N Groups

P

Pat Dools

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.
 
Top