+ Reply to Thread
Results 1 to 5 of 5

Macro to find duplicates, concatenate Unique Values, then delete old duplicates

  1. #1
    Forum Contributor
    Join Date
    07-17-2012
    Location
    N/A
    MS-Off Ver
    Excel 2010
    Posts
    218

    Macro to find duplicates, concatenate Unique Values, then delete old duplicates

    See attached macro.

    For the "ConcCols" array, can it be coded it so that it only shows unique values in the concatenated column? (should the same piece of equipment be listed twice for the same person).
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    17,401

    Re: Macro to find duplicates, concatenate Unique Values, then delete old duplicates

    See.........

  3. #3
    Registered User
    Join Date
    06-06-2013
    Location
    Moldova
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Macro to find duplicates, concatenate Unique Values, then delete old duplicates

    Quote Originally Posted by jindon View Post
    See.........
    That is fantastic. Thank you so much, Jindon. You are my new favorite person.

  4. #4
    Registered User
    Join Date
    07-05-2013
    Location
    Philadelphia
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Macro to find duplicates, concatenate Unique Values, then delete old duplicates

    Is it possible to alter this code so that it compares values from two worksheets e.g.
    1. Find duplicates, conccatenate, sum values, and delete duplicates in worksheet
    2. Then find duplicates, sum values, and delete duplicates in another workbook
    3. And finally subtract matched items ( worksheet1 - worksheet2 = worksheet3)

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    17,401

    Re: Macro to find duplicates, concatenate Unique Values, then delete old duplicates

    Aorusakwe

    You need to open your own thread by the rule.

+ 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