Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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.

share|improve this question
    
Jennifer, I've added some sample data to help illustrate what you're trying to do. If I've got it wrong please fix. –  Al E. 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 Answer 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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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