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.