Google Sheets – Dynamically Add Entries to Column Based on Logic

filterformulasgoogle sheetsgoogle-sheets-query

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?

Best Answer

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

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

Related Solutions

Google-sheets – Publish last 5 entries from a Google Form

I'm considering Problem two as off topic here but for Problem One please try something like:

=query(importrange("https://docs.google.com/spreadsheets/d/$$$$","Applicant Form Response!A:H"),"Select * order by Col1 desc limit 5")

where $$$$ is the rest of the URL for your Responses sheet.

Google Sheets – Formula for Every X Rows with Incrementing Cell Value

Please try, 1 in A2 and in A3 copied down:

=if(mod(row(),7)=2,A2+1,A2)

Best Answer

Related Solutions

Google-sheets – Publish last 5 entries from a Google Form

Google Sheets – Formula for Every X Rows with Incrementing Cell Value

Related Topic