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