+ Reply to Thread
Results 1 to 4 of 4

combine cells and delete duplicates

  1. #1
    Registered User
    Join Date
    10-26-2007
    Posts
    3

    combine cells and delete duplicates

    I am working on a list to send out holiday cards, however, I only want to send 1 holiday to card to each address. In many cases I have a husband and wife at the same address 1 holiday to card to each address.

    Please the attached example, in many cases I have a husband and wife at the same address (see rows 3 and 4 - Agnes and William Mutert). How can I combine the first names into 1 cell so that on husband and wife cases, it would be Agnes and William?
    Also, want to delete duplicates, for example rows 20 and 21 - Margaret Brueck. Only want to send 1 holiday card to herm not 2.

    Any help would be greatly appreciated. I am not sure if there is a formula or formulas that I need or if I have to do it all manually. I have about 6000 entries, so anything would be helpful.
    Attached Files Attached Files
    Last edited by VBA Noob; 10-26-2007 at 09:49 AM.

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    Try this macro which you need to paste into a new module in the VBA editor - Alt F11

    Please Login or Register  to view this content.
    Martin

  3. #3
    Registered User
    Join Date
    10-26-2007
    Posts
    3

    Thamks you so much !

    Martin,

    Thanks you very much for the macro, it is AWESOME ! The only problem I am having is on the duplicate entries, instead of deleting just one of the entries, it is combining the names....I have attached my example for your viewing for you see.

    Thank you so much, I truly appreciate the help and this has saved me hours manual work.

    Would you mind if I attached another spreadsheet to get some help on? Another project I am working on with thousands of entires as well.

    Meg
    Attached Files Attached Files

  4. #4
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    Is this better?- maybe I misunderstood your original request.

    I notice that you have a bit of a data quality issue here which will give unwanted results. In the sheet you have 12 Reba Court and 12 Reba Ct which I assume should be the same address.

    The easiest way to check for this is to look for entries where the family name occurs more than once (use countif function) and then sort then sort these by address to make it easy to spot the candidates.

    Paste

    Please Login or Register  to view this content.
    into P2 on the attachment and copy down.

    Please post your other problem as a new post. Either myself or someone else will pick it up.
    Attached Files Attached Files
    Last edited by mrice; 10-29-2007 at 03:24 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1