2

I have a list of volunteers in sheet one. They have selected what programs they want to participate in with a yes or no in the column under that program. How can I create a formula that says if this cell says yes take that row of information to another spreadsheet. This was all the people that said yes for that project are on one sheet and easier to find?

Sample data:

        | Breakfast | Lunch | Dinner
--------+-----------+-------+--------
Steve   |    yes    |   no  |   yes
Jane    |    yes    |  yes  |   yes
Bob     |     no    |  yes  |   yes
Mary    |     no    |   no  |   yes

On sheet for "Breakfast":

        | Breakfast 
--------+-----------
Steve   |    yes    
Jane    |    yes    

On sheet for "Lunch":

        | Lunch
--------+--------
Jane    |  yes
Bob     |  yes

etc.

  • Jennifer, I've added some sample data to help illustrate what you're trying to do. If I've got it wrong please fix. – ale Sep 23 '13 at 16:12
  • Do you want the info to be moved physically from one sheet to another? – Jacob Jan Tuinstra Oct 17 '13 at 14:23
1

Breakfast

=QUERY(data!A2:D;"SELECT A WHERE B='yes'")

Lunch

=QUERY(data!A2:D;"SELECT A WHERE C='yes'")

Dinner

=QUERY(data!A2:D;"SELECT A WHERE D='yes'")

Assuming that the Sample data is in data!A:D

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.