How to Use Google Sheets' QUERY Function - Explained with Examples
Channel: ExcelStrategies
Date: 2019-05-03

One of most versatile Sheets’ functions is the QUERY function. Its SQL-like syntax allows us to retrieve specific information from our worksheet, enabling various filtering, sorting, lookup, and aggregation capabilities. While this function is more powerful than INDEX/MATCH, VLOOKUP, SUMPRODUCT, SUMIFS and others, its syntax is rather simple: QUERY(Data, Query, [Headers]) .

http://blog.excelstrategiesllc.com/2018/12/20/working-with-google-sheets-query-function/

https://docs.google.com/spreadsheets/d/1hJ4B1Hiis65GtP7StNLNmWp0Cy5GrGLHFm3yRL3mHWU/copy

Connect with us: 
http://Blog.ExcelStrategiesLLC.com 
http://Twitter.com/ExcelStrategies 
http://LinkedIn.com/in/ExcelStrategies