Results 1 to 7 of 7

Thread: Duplicate Issue. Data was merged from 5 lists, not all exactly the same.

  1. #1

    Duplicate Issue. Data was merged from 5 lists, not all exactly the same.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a list of around 45k entries... there's easily half of them that are listings for a business that shows more than one time on the BBB as well as some entries that came from multiple lists where one has the secondary address info listed in the primary address field, and others separately, that's a majority of them. Some have alternate addresses altogether, some have emails and some dont. I have spent a lot of time on collating this list and need to clean it out as much as I can. I've exhausted my Excel skills at this point. Took me half a day to clean it up so it was usable and everything was formatted properly - this list is being used as a mailing list (snail mail) and it needs to be perfect.

    Any suggestions?

  2. #2
    Super Moderator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    715
    Articles
    0
    Attach a sample workbook.
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3

  4. #4
    As you can see, there are businesses with multiple locations... Any way to run a macro or something like that and delete all entries after the first one?

  5. #5
    Super Moderator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    715
    Articles
    0
    Attach the workbook, not a picture of it.
    Ali
    Enthusiastic self-taught user of MS Excel!

  6. #6
    Book1.xlsx

    Here's the 'Z' section... you can see the duplicates.

  7. #7
    Sorry - didn't attach.
    Attached Files Attached Files

Posting Permissions

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