Results 1 to 4 of 4

Merge/Purge data in Excel

This is a discussion on Merge/Purge data in Excel within the Excel Questions forums, part of the Question Forums category; Is there a simple way to merge two Excel spreadsheets and purge the duplicate records? For example, in a customer ...

  1. #1
    New Member
    Join Date
    Nov 2006
    Posts
    1

    Default Merge/Purge data in Excel

    Is there a simple way to merge two Excel spreadsheets and purge the duplicate records? For example, in a customer file, I want to compare addresses or phone numbers and delete an entire record if it is a match. The way that I am currently performing this is very cumbersome. There must be a better way, need assistance. Thanks.

  2. #2
    MrExcel MVP
    Moderator
    Smitty's Avatar
    Join Date
    May 2003
    Location
    Crested Butte, CO
    Posts
    27,134

    Default

    Welcome to the Board!

    You could use Advanced Filter-->Unique Records only after appending the lists together.

    Or here's a link to the MSKB with a VBA method:

    How to use macros to delete duplicate items in a list in Excel 2000.

    Hope that helps,

    Smitty
    Smitty

    Every once in a while, there's a sudden gust of gravity...

    Check out my new book at the Mr. Excel Bookstore!

    Mr. Excel HTML Maker - Post a shot of your sheet

  3. #3
    New Member
    Join Date
    Jul 2009
    Posts
    2

    Default Re: Merge/Purge data in Excel

    Hello,

    Do you need any software to merge and purge?

    Thanks

  4. #4
    New Member
    Join Date
    Jul 2009
    Posts
    2

    Default Re: Merge/Purge data in Excel

    Do you have to merge and purge your sheets or data? For this there are many software to solve the problem. Better you can use that kind of merge purge software.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com