+ Reply to Thread
Results 1 to 5 of 5

Concatenate single instance of duplicates

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    07-16-2009
    Location
    NA
    MS-Off Ver
    MS Excel 2010
    Posts
    237

    Concatenate single instance of duplicates

    I don't know who this could be done as I don't know if it's possible. I have list of names in S13 and T13, last name and first name. This list is based on duplicates, so a name might pop-up 5 times. The problem is that it also contains duplicates of the same last name but the first name is different.
    So, is there a way concatenate the last and first name, in such a way that will display only a single instance of duplicated name?
    Hope I was clear enough.

    S13 T13
    John Fred
    Taia Alice
    Taia Alfred
    John Fred
    Taia Alice

    And the result will be something like this:
    John Fred
    Taia Alice
    Taia Alfred

    Thanks for your time

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: Concatenate single instance of duplicates

    Hi,

    run a formula like

    =A1&" "&B1 and copy down (adjust cell addresses first), then use the Remove duplicates command on the Data ribbon.

    hth

  3. #3
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: Concatenate single instance of duplicates

    or just highligh both columns and use advanced filter unquie records
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  4. #4
    Forum Contributor
    Join Date
    07-16-2009
    Location
    NA
    MS-Off Ver
    MS Excel 2010
    Posts
    237

    Re: Concatenate single instance of duplicates

    yes but how do I use that as an automated sollution? The columns with names are actually a links to .txt files. So when i refresh the connections, the names should be sorted automatically and placed in a new column. Sorry about the concatenate, it wasn't really needed.

  5. #5
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: Concatenate single instance of duplicates

    some thing like
     Range("A1:B8").AdvancedFilter Action:=xlFilterInPlace, Unique:=True
    Some times to help with the you can record a marco while performing the operations
    then look at the recorded macro script
    Last edited by pike; 12-01-2009 at 07:05 AM. Reason: tags

+ 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