I have done something similar to this.

Did it in two steps....

Assuming you list is in range (A2:A50001) allowing for headers

in B2: =countif($A$2:$A$50001,A2)

This will count the total entries of that company in the list. Copy it
down the list, then use a filter to only show rows with a value in
column B greater than 1.

This will show all the companies that have multiple entries, but will
also still have multiple entries for those companies


Next,
copy the filtered list in column A to another sheet.

Now using the "Advanced Filter" on your new list, select the Action
"Copy to Another Location", put in a new cell reference for your final
list to appear in the "Copy to:" option, and check the "Unique records
only" box.

Hit OK and you should be left with a list of the companies that appear
more than once from your original list.

A bit long winded to write, but takes only about 30secs to do !!

If you want to know how many times they appear, just do VLOOKUP against
your first list with column B returning the results......


--
strobinson1
------------------------------------------------------------------------
strobinson1's Profile: http://www.excelforum.com/member.php...o&userid=36124
View this thread: http://www.excelforum.com/showthread...hreadid=559220