View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pat Dools Pat Dools is offline
external usenet poster
 
Posts: 15
Default 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