+ Reply to Thread
Results 1 to 3 of 3

Vlookup pulling two or more cells of text into one cell without showing duplicates

  1. #1
    Registered User
    Join Date
    06-26-2012
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2010
    Posts
    9

    Vlookup pulling two or more cells of text into one cell without showing duplicates

    Similar post:
    http://www.excelforum.com/excel-form...y-a-comma.html

    I have found this post with a formula that works for what I am trying to do but I would like to figure out a way to edit it to not repeat items that are duplicates. I have a similar worksheet but mine has duplicates for example, to be consistent with the already attached workbook:

    1/12 The Ghost
    1/13 The Zombie
    1/12 The Bike
    1/12 The Ghost
    1/12 The Ghost
    1/12 The Zombie

    Instead of showing up for 1/12 as - The Ghost, The Bike, The Ghost, The Ghost, The Zombie
    I would like it to say - The Ghost, The Bike, The Zombie

    Is this possible

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Vlookup pulling two or more cells of text into one cell without showing duplicates

    Make a list with unique values (excel 2007 => data => remove duplicates)

    After that you can use the code below.

    I found the code below, on the site from jerry beaucaires.

    It will do what you're asked for.

    https://sites.google.com/a/madrocket...ssistant/files

    Please Login or Register  to view this content.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    06-26-2012
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Vlookup pulling two or more cells of text into one cell without showing duplicates

    Unfortunately I the data I have I need to keep the duplicates. I have found the formula below which works but does show duplicates

    =IF(F2="","",INDEX(B:B,MATCH(F2&"_1",C:C,0))&IF(COUNTIF(A:A,F2)>1,", "&INDEX(B:B,MATCH(F2&"_2",C:C,0)),"")&IF(COUNTIF(A:A,F2)>2,", "&INDEX(B:B,MATCH(F2&"_3",C:C,0)),""))
    Attached Files Attached Files

+ 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