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.
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.