Home Tags Query Function

Tag: Query Function

Using Field Labels in Query Formula in Google Sheets

Reference a Column by Field Label in Google Sheets QUERY

0
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

0
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

0
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...
Query Tips 2023

How to Return Unique Rows in Google Sheets QUERY

0
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

0
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

0
Sum by the week of the month and by the week of the year is different. In this Google Sheets tutorial, we are discussing...