Query in Google Sheets: Difference between revisions
From Cramsession
Jump to navigationJump to search
✍️ Verified Author: Mflavell • Click to view professional profile & credentials
No edit summary |
No edit summary |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
Create a blank sheet | |||
On line A:1 use | On line A:1 use | ||
=query('your data'!A:AJ, "select * where C='Something'", 1) | =query('your data'!A:AJ, "select * where C='Something'", 1) | ||
Where: | |||
* '''your data''' is the name of data sheet you want to query | * '''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. | |||
Latest revision as of 17:49, 8 August 2025
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.
