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
Watch video Filtering IMPORTRANGE data with QUERY in Google Sheets online, duration hours minute second in high quality that is uploaded to the channel Yagisanatode -Scott- 11 May 2022. 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 4,583 times and liked it 53 visitors.
