Query and importrange

22 views
Skip to first unread message

Man of grace

unread,
Feb 18, 2018, 10:54:44 AM2/18/18
to Google Visualization API
I have a form feeding a master spread sheet. From that master spreadsheet I want to import specific rows to other spreadsheets based on a single column cell. The column is age and the spreadsheets to feed are for age groups. The form field is type your age.This it what I am using to import rows for groups 0-2 and group 12-18.

=query(importrange("key","Youth Master List!B2:Q1000"),where col3 <=2")

=query(importrange("key","Youth Master List!B2:Q1000"),where col3 >=12")

The problem I am having is bringing info in for a group age range of 3-4 and also 5-11. I can't seem to figure out how to get the "where" to target these other age ranges.

Reply all
Reply to author
Forward
0 new messages