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!
Bookmarks