Sunday, August 12, 2012

yogi_Extract List of Unique Items From A Column Of Comma Delimited Strings

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #687   Aug 12, 2012     www.energyefficientbuild.com.

user a_p3rson said: (http://productforums.google.com/forum/?zx=7duiqdyoctok#!category-topic/docs/spreadsheets/cbRvbvjPNNc%5B1-25%5D)
List of unique comma-space separated responses
I have a column of text responses, which are all short responses. However, each cell (may) contains more than one response, separated by a comma-space. How do I get a list of the unique responses? An example would be:
H1: Circle, Square, Triangle
H2: Octagon, Triangle
H3: Octagon
H4: Diamond, Circle
would return:
Circle
Square
Triangle
Octagon
Diamond
(in no particular order, however.)

---------------------------------------------------------------------------------------
following is a solution to a bit more generalized problem in the sense that I have extracted list of unique items from strings of comm-space sepatreated, or comma separated items in a column

No comments:

Post a Comment