Most versatile effective function and unique to Google Spreadsheets. I am documenting this function to understand it properly and for those who do not have programming background. I do not have previous experience with query. i will try to illustrate with examples.
If you have confusion and stuck some where please post your questions Google Docs forum at the following link https://productforums.google.com/forum/#!categories/docs/spreadsheets. There are experts in this area waiting for your questions.
Google Spreadsheet query is designed to be similar to SQL with few exceptions. it is a subset of SQL with a few feature of its own. if you are familiar with SQL it will be easy to learn.
The Syntax of the function is as follow:
QUERY(data, query, headers)
DATA: it can be columns(A:C open ranges) of data you want to query, range of cells such as A1:C10, result of function such as importrange, index etc.,
View original post 741 more words