Filtering IMPORTRANGE data with QUERY in Google Sheets
The starter sheet: https://docs.google.com/spreadsheets/...
Easter Eggs 🥚 and bonus useful formulas for the curious inside.
The written tutorial: https://yagisanatode.com/2022/05/11/f...
The IMPORTRANGE series: • Google Sheets - IMPORTRANGE | The com...
Learn how to use the FILTER function in Google Sheets to filter source data within an IMPORTRANGE function with 4 key examples:
00:00 Intro
00:36 E.g. 1 - Filter a company's data.
05:37 E.g. 2 - Select only specific columns
08:23 E.g. 3 - Ordering by the 'Total' column
09:28 E.g. 4 - Filter by company and sales rep
More advanced FILTER tips:
Google Sheets: How to use OR inside a FILTER - https://yagisanatode.com/2020/02/15/g...
If you like the video, check out my website:
https://yagisanatode.com/
Here is the link to just Google Sheets tutorials:
https://yagisanatode.com/google-sheets/
Get your copy of the Google Sheet Project Task Manager here: yagisanatode.teachable.com/p/google-sheets-project-tasks-manager
Sign up for my course:
Google Sheets: Learn the Essentials with Three Detailed Projects
https://yagisanatode.teachable.com/p/...
Grab a Google Sheets Shortcuts Mousepad to help you memorise the Shortcuts.
https://www.zazzle.com.au/collections...
#GoogleSheets #Spreadsheets #GoogleEdu #administration #GoogleWorkspace
Смотрите видео Filtering IMPORTRANGE data with QUERY in Google Sheets онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал Yagisanatode -Scott- 11 Май 2022. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 4,583 раз и оно понравилось 53 посетителям.
