Duplicate Checking

[niladri20052006]

Hi All,

I have huge list of company names. But I am unable to check duplicate companies. Yes I am doing advance Filter or Pivot Table. But the problem is company names is like the below:

Cisco Systems
Cisco Systems,
Cisco Systems, Inc
Cisco Systems, Inc.
Cisco Systems, Incorpoarted
The Cisco Systems

Like this I have a huge list of different companies name. Is there any to solve this at a time?

Thanks in advance!

 

[taurean]

Few days back while trolling on this site I had come across this interesting thread. I think you need something on the similar line.
http://www.mrexcel.com/forum/showthread.php?t=195635&highlight=FUZZY+LOOKUP

If the link does not work then try those keywords: FUZZY LOOKUP...!

 

[justanotheruser]

Not entirely sure, but do the company names have something in common that you could look for - for example in the above list "Cisco Systems" and then you could do something like an IF the cell contains the phrase "Cisco Systems" , then "DUPLICATE" - then you can filter and remove dups?