+ Reply to Thread
Results 1 to 4 of 4

How do i search through a column then return unique criteria disregarding commas?

  1. #1
    Registered User
    Join Date
    08-30-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    2

    How do i search through a column then return unique criteria disregarding commas?

    Hello everyone, I am new here and I found this forum while search for a "place" where i could get some help with my problem in excel

    In a column, I have a series of "content keywords" separated with commas. What I would like to achieve, is to have another column named "unique content keywords" to display unique entries from my "content keywords" column.

    For example, in the "content keywords" column, I have the following:

    Row 1: apple
    Row 2: ball
    Row 3: apple, ball
    Row 4: cat
    Row 5: apple, cat
    Row 6: ball
    Row 7: apple

    I would like to be able to display under "unique content keywords" the following:
    Row 1: apple
    Row 2: ball
    Row 3: cat

    When I try to use the unique function, this is what I get:
    Row 1: apple
    Row 2: ball
    Row 3: apple, ball
    Row 4: cat
    Row 5: apple, cat

    another example:

    excelhelp.PNG


    Thank you in advance!

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: How do i search through a column then return unique criteria disregarding commas?

    Hi
    try this macro
    you will need to change the values of the range InputRange to the source range, and OutputCell to be the first cell to begin your list of unique values (others will be listed below it)

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-30-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: How do i search through a column then return unique criteria disregarding commas?

    Thank you for your reply! I am new in using excel formulas and up until now I haven't had any experience in programming and macro in excel.. so i do not know how to use that code.. >_<

    but after searching around the net for a while.. *voila*

    your code works so fine, thank you so much!

    :D

    i am sorry but i forgot to add this: is it possible to make this not case-sensitive?

  4. #4
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: How do i search through a column then return unique criteria disregarding commas?

    Hi
    try this

    Please Login or Register  to view this content.
    Last edited by NickyC; 09-01-2012 at 11:26 PM. Reason: change code slightly

+ 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