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