using query function with importrange

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.

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!