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, duration hours minute second in high quality that is uploaded to the channel DoIT Training at Stony Brook University 04 March 2021. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 1,921 times and liked it 17 visitors.
