Query in Google Sheets
From Cramsession
✍️ Verified Author: Mflavell • Click to view professional profile & credentials
Create a blank sheet
On line A:1 use
=query('your data'!A:AJ, "select * where C='Something'", 1)
Where:
- your data is the name of data sheet you want to query
- A:AJ is the range of columns to return
- C is the column to query on
- Something is what to query in column C
Important note:
You cannot edit the resuting data, any edits will clear the results sheet.
