yogi_Pull Data From Select Columns of Sheet1 For Matching Location Part3

                                          Google Spreadsheet   Post  #1322
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug, 8 2013
user  nerfsmurf (http://productforums.google.com/forum/?zx=rmr1dj2nv5qa#!category-topic/docs/spreadsheets/rgB2B0udwd8)

this is (Part3) an extension to the solution in my following blog posts

yogi_Pull Data From Select Columns of Sheet1 For Matching Location

http://yogi--anand-consulting.blogspot.com/2013/07/yogipull-data-from-select-columns-of.html
and
yogi_Pull Data From Select Columns of Sheet1 For Matching Location Part2

http://yogi--anand-consulting.blogspot.com/2013/08/yogipull-data-from-select-columns-of.html

_________________________________________________________________________________

Displaying multiple values of cells within a column if a certain text value is in same row.

I made a mistake in the example I sent to your guys...

In the first example, I only had 1 comment per entry. Realistically, I will have multiple comments per entry. I edited the sheet:

https://docs.google.com/spreadsheet/ccc?key=0AmkzyfXfhi8XdHk0eVI5dFBYMGl2MEtmOUdtUlZHamc&usp=sharing

and highlighted the column and the results.

Thanks to the both of you for your replies. If this is too hassle much then please ignore!

Thanks again for your efforts!

Williams

-------------------------------------------------------------------------------------------------------------------------------------------------

yogi_Pull Data From Select Columns of Sheet1 For Matching Location Part2

                                          Google Spreadsheet   Post  #1321
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug, 8 2013
user  nerfsmurf (http://productforums.google.com/forum/?zx=rmr1dj2nv5qa#!category-topic/docs/spreadsheets/rgB2B0udwd8)

this is an extnsion to the solution in my following blog post

yogi_Pull Data From Select Columns of Sheet1 For Matching Location

http://yogi--anand-consulting.blogspot.com/2013/07/yogipull-data-from-select-columns-of.html

Displaying multiple values of cells within a column if a certain text value is in same row.

Hey Yogi! Again, many thanks for your help! I left 2 things out of the first example, however. 

My Google form has multiple comment sections after every section so on the spreadsheet I have multiple comment columns. And I would also like to filter which comments are displayed based upon date.

Enough with the explanation, here is the same example, just a bit modified.

https://docs.google.com/spreadsheet/ccc?key=0AmkzyfXfhi8XdHk0eVI5dFBYMGl2MEtmOUdtUlZHamc&usp=sharing

---------------------------------------------------------------------------------------------------------------------------------------------

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     www.energyefficientbuild.com.   Jul 29, 2013
user  nerfsmurf (http://productforums.google.com/forum/?zx=6q0rj6nbkpey#!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?

-------------------------------------------------------------------------------------------------------------------------------------------------