Hi,

You may try this

Assume that your data is in range D6:E18. In D5:E5, there is Name and
Description (headings). In cell F5, type Occurrence. In F6, type
=COUNTIF($D$6:$D$18,D6) and copy down. Type Occurrence in cell D20. In
cell D21, type =MAX(F6:F18).

Now go to Data Filter Advanced Filter and in the Actioin section,
select, "Copy to another location". In the list range, select D5:F18. In
the criteria box, select D20:D21 and in the copy to box, select a blank cell
on the worksheet. Now click on OK.

This will transfer the data to the new range.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"kristy_6278" wrote in message
...
Hello,

I am working on an excel document and I need to find out the top 10
publications in column E and then I need to match these top 10 against
the
service lines in column J.

I have over 10000 lines and there are over 40 publications and 4 different
service lines. A lot of people have said do the autosort and count, but I
would be here all day.

Is someone able to help me?
--
WitkosRobinson