I have a large list of companies, around 20,000 (all in a sinlge list). There are numerous duplicate entries in the list but with different spellings or abbreviations, e.g. you might have ABC Inc and ABC Incorporated and ABC Corp and so on and many other variations on a theme. Equally you might also have the same company in the list several times, but different branches, so in that case, it isn't a duplicate. I have the company name, the address, in some cases the town and county and the postcode, but it isn't inconceivable that postcodes could be incorrectly entered in some cases or that two different companies share a postcode.

I need to find a way to easily and quickly identify duplicate entries in this 'single' list. A Fuzzy lookup would be perfect but I think this only works on two lists, does anyone know of anyway to achieve a similar thing on a single list?

Many thanks