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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cumulative counting 3
top ten filter 2
top ten ranking 0
pivot table top 60-80% 2
If then Formula 3
Calculating Differences between columns in a Pivot Table 3
Automatic splitting of data to several files 2
Customized Report Summary? 4

Top