Monday, July 29, 2013

yogi_Pull Data From Select Columns of Sheet1 For Matching Location

                                          Google Spreadsheet   Post  #1311
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jul 29, 2013
user  nerfsmurf (!mydiscussions/docs/rgB2B0udwd8)
Displaying multiple values of cells within a column if a certain text value is in same row.
Good morning everyone! 

Made the title as specific as I could! Here is the complete version.

I have a Google form that give every row a category within a spreadsheet, lets use for example, "Store Name" in Column B. and B2:B900 can have either value "Store A", "Store B" or "Store C".

Also within the same Google form, there is a comment section. So in the spreadsheet, a row will include the name of the store and a few columns over, the comment.

I'm trying to list the data on a new sheet as follows: Column A will have all comments from store A, Column B will have all comments from store B and Column C will have all comments from store C.

I am currently using:

=iferror(INDEX('Form Responses'!$S$2:$S$902, MATCH(0, COUNTIF(C$23:$C24,'Form Responses'!$S$2:$S$902), "0")))

S is my comment column and C is my destination column where I need the data displayed.

I drag this formula down about 50 rows so I can see 50 comments, and it works except that it shows all comments. I have tried to fuse the FILTER function in there but with no luck.

Can anyone help?