Yes, filter duplicates is easy if the data is formatted the same.
However, I have two columns of company names - they are from different data sets so they are formatted differently.
Example:
Column A: Ziegler-Peru, Inc.
Column B: Ziegler Peru, Inc
Column A: ConocoPhillips Company
Column B: Conoco Phillips
..In this situation, what is the best way to check column A for duplicates in column B?
I think I would create two helper columns, C and D. C would reflect A and D would reflect B.
Then you need to use SUBSTITUTE to remove all the potential "anomalies" ... spaces, hyphens, commas, etc.
You can nest SUBSTITUTE but it could be "tedious". You might also need to elininate whole words like "Inc" and "Company".
Having rationalised both columns of data, you can then have a further column where you compare the values in columns C and D, say column E. Use COUNTIF or VLOOKUP to identify matches/duplicates.
Then filter on column E for duplicates.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks