I have a list of people that I have a drop down for if they are attending or not to an event.

If "Yes" I want them to be added to another column on sheet 2. Except I don't know how to add them dynamically. So if I have 50 people and only 10 say yes, how do I have the first 10 rows populate with the people?

I think excel has a table/object ability but I don't see this in excel.

Any ideas?

1 Answer 1


=FILTER(A:A, B:B="yes")


=QUERY(A:B, "select A where B='yes'")


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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