Results 1 to 2 of 2
Thread: Adress De-duplication
2001-01-14, 18:44 #1Arjan-BlaauwGuest
Is there a way to use excel tot de-duplicate different adress-files?
I checked on http://www.cpearson.com/excel/duplic...tractingUnique
I think a can use the option used under the header
'Extracting Unique Entries' but I believe that you then can only check on one value. I want to check on multiple entries like postcode, pobox number and company name.
Is this possible or do I have to do such things in Access (which I'm not good at)
2001-01-14, 22:51 #2
- Join Date
- Jan 2001
- Newcastle, New South Wales, Australia
- Thanked 0 Times in 0 Posts
Re: Adress De-duplication
There are lots of threads here about checking for duplicates, but one that might work is to create a new column containing the concatenation of the separate entries;
eg putting in A1 the formula
where B1 contains POBox, C1 contains Postcode, D1 contains CompanyName for instance would give a string with them all together. You can get fancy and use =A1&", "&B1&", "&C1 but this just makes it easier to read, not necessarily to use.
Then you can check the duplicates on this single column