Query in Google Sheets: Difference between revisions
From Cramsession
Jump to navigationJump to search
✍️ Verified Author: Mflavell • Click to view professional profile & credentials
(Created page with "* Create a blank sheet On line A:1 use =query('your data'!A:AJ, "select * where C='Something'", 1)") |
No edit summary |
||
| Line 4: | Line 4: | ||
=query('your data'!A:AJ, "select * where C='Something'", 1) | =query('your data'!A:AJ, "select * where C='Something'", 1) | ||
* '''your data''' is the name of data sheet you want to query | |||
Revision as of 19:10, 6 March 2025
- Create a blank sheet
On line A:1 use
=query('your data'!A:AJ, "select * where C='Something'", 1)
- your data is the name of data sheet you want to query
