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