QUERY
Google Sheets QUERY and UNIQUE explained with tested examples: sorting by several columns, filtering, totals and data from other sheets.
-
UNIQUE Without Blanks in Google Sheets (and Other Hidden Duplicates)
UNIQUE returns each distinct value of a range once, and an empty cell counts as a value. So a list with gaps, or a range that runs to the bottom…
-
Google Sheets QUERY: ORDER BY Multiple Columns, Tested
To sort a QUERY by more than one column, list the columns after order by, separated by commas, each with its own direction: =QUERY(A1:F8, “select A, B, D order by…
-
QUERY from Another Sheet or Spreadsheet in Google Sheets
QUERY doesn’t care where its data lives. Point the first argument at another tab and it works the same as on the current one; wrap that argument in IMPORTRANGE and…