Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #601 Jun 28, 2012 www.energyefficientbuild.com.
user Grumpathy said:
Copying a column on data using another column as a criteria
I would like to find a way to pull all data from a column IF the data in another column matches a specific criteria.
user Grumpathy said:
Copying a column on data using another column as a criteria
I would like to find a way to pull all data from a column IF the data in another column matches a specific criteria.
As an example:
I would like to pull the comments ('Sorted Data' column F) from a specific store ('Sorted Data' column A) and list them all together, so that I get all the survey comments from New York, all the survey comments from Atlanta, etc.
Is there any way to do this?
----------------------------------------------------------------------------------------
in the following solution to the problem I have cross tabbed the comments directly from Form data sheet into Survey Comments sheet
This works great! Thank you very much!
ReplyDeleteYou Are Very Welcome Grump Athy ... Now Let Us Keep Googling.
ReplyDeleteCheers!
Yogi
Cloud Computing -- Google Docs Way
yogi--anand-consulting.blogspot.com