Filtering IMPORTRANGE data in Google Sheets with FILTER

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
01:01 E.g. 1. FILTER a selected client
06:26 E.g. 2. FILTER a selected client & SORT
08:52 E.g. 3. FILTER a selected sales rep
12:07 E.g. 4. FILTER selected sales rep sales greater than $1,000

More advanced QUERY tips:
- How to get the most frequently appearing words in a column with QUERY - https://yagisanatode.com/2021/10/19/h...
- Google Sheets: Counting and Filtering Rows where Cells Contain Particular Values. - https://yagisanatode.com/2019/10/05/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