Google Sheets Query formula (See the Description For More)
Query lets you pull out specific data from your main data into a new, read-only table. You can then make charts, do calculations, etc., from that subset of your main data. It's a very powerful but potentially confusing and complicated formula, but totally achievable!
Slides: https://docs.google.com/presentation/...
Copy Demo Sheet to follow along: https://doittraining.page.link/copyqu...
Why Query? 0:00
Write a basic query formula 0:52
Specify which columns to return 1:59
Specify criteria for which rows to return number criteria 2:38
Which rows to return, word/string criteria 4:20
Multiple conditions for which rows to return 5:28
Specify how to sort/order returned data 3:20
Specify limit on returned data 5:55
EXTRA: Find Sum/Avg/Count Without Formulas (to work with your query data) 6:35
Learn more: 7:10
https://support.google.com/docs/answe... and https://developers.google.com/chart/i...
Watch video Google Sheets Query formula (See the Description For More) online without registration, duration hours minute second in high quality. This video was added by user DoIT Training at Stony Brook University 04 March 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,921 once and liked it 17 people.