I am importing data from a Google Form to a Google Spreadsheet.

I have created a query to compile data from the response tab to 4 different tabs in the spreadsheet.

I have put a limit on the number of results that can be placed on each tab.

The respondent gets 4 choices (red, blue, yellow, green). If red has reached the limit that can be added to that tab, how do I make the query look to the next choice, blue and so on?

Here is my query so far:

=query('Form Responses 1'!A:E,"Select * Where D='Blue' Limit 10", 1)

1 Answer 1


Use offset

The offset clause is used to skip a given number of first rows. If a limit clause is used, offset is applied first: for example, limit 15 offset 30 returns rows 31 through 45.

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.