Query Functions in Google Sheets
Google Sheets
How to Use Wildcard Characters in Google Sheets Query
You can use the % sign as a wildcard character in Google Sheets queries:
Method 1: Return Cells That Start with Certain Characters
=QUERY(A1:A10, "Select A...
Google Sheets
Google Sheets Query: How to Use Multiple Criteria in Query
You can use the AND and OR operators to perform a Google Sheets query with multiple criteria.
Example of AND Operator:
=QUERY(A2:C10, "select A, B, C...
Google Sheets
Google Sheets Query: How to Use Cell Reference in Formula
You can use the following basic syntax to use a cell reference in a Google Sheets query:
=QUERY($A$1:$B$11, "Select B where A contains '"&D3&"'")
In this...
Google Sheets
Google Sheets: How to Query From Multiple Sheets
You can use the following basic syntax to query from multiple sheets in Google Sheets:
=QUERY({Sheet1!A1:C9;Sheet2!A1:C9;Sheet3!A1:C9})
You can also use the following syntax to select specific...
Google Sheets
Google Sheets Query: How to Create a Pivot Table
You can use the following syntax to create a pivot table using Google Sheets Query:
=query(A1:C13, "select A, sum(C) group by A pivot B")
In this...
Google Sheets
Google Sheets Query: How to Use Group By
You can use the following syntax to group and aggregate data in a Google Sheets Query:
=query(A1:D12, "select B, avg(D) group by B", 1)
In this...
Google Sheets
Google Sheets Query: How to Use Order By
You can use the following syntax to order the results of a Google Sheets Query by a certain column:
=query(A1:C12, "select A, B order by...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read