Published: 14 Jan 2019 › Updated: 14 Jan 2019
using query function with importrange
Google spreadsheets support query easily.
If you use importrange, column position name was changed.
That's time, you can use 'col#' notation.
A is Col1, B is Col2 ...........
Condition syntax rules are same with general notations.
Leave using query function with importrange to:
Best Posts From zero6pak
We have not curated any of zero6pak's posts yet. But you can encourage our curation team to review posts by visiting them regularly and by referring other readers. Because we give priority to frequently read content.
More Posts From zero6pak
- google query label replacement when using "group by"
- Date Time Replacement In IFTTT with settings and functions
- using query function with importrange
- Enumeration of dates between 'startdate' and 'enddate' using Custom function
- Managing working time using IFFTT (Location based)
- My favorite function ARRAYFORMULA in Google Spreadsheet
- Google Spreadsheet to Google Calendar using Zapier
- eval function in google spreadsheet; multi rows
- Date Time Replacement In IFTTT with google script
- Google spreadsheet data to Google Contact using Zapier