How to gt Top N records/Top N Groups
 

Assuming that the data changes over time, I suggest that you use sorting.

If you sort by Sales descending, you can pick the top 5, the top 10,
anything you like.
--
Gary''s Student
gsnu200709


"Pat Dools" wrote:

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