using query function with importrangezero6pak (25)in #spreadsheet • 6 years ago 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. #script #importrange #google #query