Google Sheet Query

[thedoctor]

Dear All,

 

I have students choosing their GCSE options via a Google Form which then populates their options in a google sheet. I then break down the choices into each separate subject sheets.

 

What I want to do is create an automatic list i.e. when somebody chooses art then their name is populated in the art sheet. I hope this makes sense.

 

Is there a formula that can help with this?

 

I look forward to any responses to my query.

 

Many Thanks

 

James

[DGardiner]

Dear All,

 

I have students choosing their GCSE options via a Google Form which then populates their options in a google sheet. I then break down the choices into each separate subject sheets.

 

What I want to do is create an automatic list i.e. when somebody chooses art then their name is populated in the art sheet. I hope this makes sense.

 

Is there a formula that can help with this?

 

I look forward to any responses to my query.

 

Many Thanks

 

James

SO are you wanting seperate documents? or Seperate sheets on one workbook?

[thedoctor]

Yes. One Main sheet with all student's GCSE options and then a breakdown of a seperate sheet for each subject in one workbook please.

[DGardiner]

On the art Sheet if its on the same document, put this in a1 on the art sheet and adjust the query to suit:

 

=QUERY('Form responses 1'!A:BN,"select * where B contains 'Art'")

 

'Form responses 1'!A:BN = Your response sheet/columns

 

where B contains = whichever colum you have the class selections in

 

'Art' = whatever you want to search for in the previous column

Edited February 14, 2023 by DGardiner

[Face-Man]

I think this youtube video explains what you want to do