Tag: Query Function
Reference a Column by Field Label in Google Sheets QUERY
Here we'll explore the two best methods for referencing a column by its field label (header row value) in the Google Sheets QUERY: Named...
Filter Rows Based on Criteria List with Wildcards in Google Sheets
We can use a criteria list for filtering a table based on multiple conditions in Google Sheets. But what if this list contains wildcards...
Google Sheets QUERY: Select Different Columns Each Day
Using the TODAY function, we can select different columns each day in Google Sheets QUERY. This can be helpful in two ways:
Select column 5...
How to Return Unique Rows in Google Sheets QUERY
With the help of the UNIQUE and SORTN spreadsheet functions, we can return unique rows in Google Sheets QUERY.
We usually use the UNIQUE function...
Format a Date Without Converting it Into a Text – Google Sheets
Can we format a date from "DD/MM/YYYY" to "DD-MMM-YYYY" using a formula without converting it into text in Google Sheets?
My answer is "Yes."
We can...
How to Sum by Week of the Month in Google Sheets
Sum by the week of the month and by the week of the year is different. In this Google Sheets tutorial, we are discussing...