Results 1 to 2 of 2
  1. #1

    Adress De-duplication

    Is there a way to use excel tot de-duplicate different adress-files?

    I checked on

    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)

  2. #2
    Star Lounger
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts