Thursday, June 28, 2012

yogi_Cross Tab Comments By Store Name In Sheet Named Survey Comments From Sheet Named Form Data

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


2 comments:

  1. This works great! Thank you very much!

    ReplyDelete
  2. You Are Very Welcome Grump Athy ... Now Let Us Keep Googling.

    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete