Not sure what data determines the top 10 but look at the LARGE function to
see whether that will meet your need.

"Mike F." wrote:

Thanks for the advice but I need the data to appear on a seperate sheet and
in order from the greatest to the least, autoffilter does not sort the
information in that order.

Mike F

"Kevin B" wrote:

Have you tried using AutoFilter, located on the DATA option of the Excel menu
--
Kevin Backmann


"Mike F." wrote:

I need to be able to extract from a table of data and list on a seperate page
the top 10 Agents. I need the list to show name and how many times. I need
this based on the top 10 agents.