AutoFiltering for Top10

[Jenn]

Hi,

I was wondering if there are certain rules of thumb or hints I should
be aware of when trying to use this feature.

I have about 3000 lines of data that I'd like to filter. The field
has many duplicates and so I'd like the top 10 customers with the most
instances to show only. When I use the filter, nothing happens at
all. I have a few sheets like this -- some have more than 10
customers and some have fewer than 10. I'm basically looking to rank
them.

I know I can use subtotals, but I thought that was what this feature
was to do.

Am I misunderstanding the purpose of this feature?

Thanks for your input,
Jenn

 

[Debra Dalgleish]

You could use a PivotTable to summarize the data, and use its top ten
feature to show the customers with the most instances.

There are some instructions, and links to information here:

http://www.geocities.com/jonpeltier/Excel/Pivots/pivotstart.htm