Results 1 to 4 of 4

combine cells and delete duplicates

Threaded View

megkelley combine cells and delete... 10-26-2007, 09:45 AM
mrice Try this macro which you need... 10-26-2007, 02:07 PM
megkelley Thamks you so much ! 10-27-2007, 04:29 PM
mrice Is this better?- maybe I... 10-28-2007, 05:55 AM
  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.

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