Why not just sort the listing on:
1) Company Name (Field) - Ascending
2) County Name (Field) - Ascending
Just a thought..

"Mike JM" wrote
in message :

Hi

I wonder if somebody could help me, I have a list of about 50,000
companies in Excel, which is split over 10 countries, I want to find
companies that appear more than once in the list, therefore finding out
who operates in more than one company.

Could anybody tell me how to do this?

Any information would be fantastic.

Many thanks

Mike


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