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...
Смотрите видео Google Sheets Query formula (See the Description For More) онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь DoIT Training at Stony Brook University 04 Март 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,921 раз и оно понравилось 17 людям.