Filtering IMPORTRANGE data in Google Sheets with FILTER

The starter sheet: https://docs.google.com/spreadsheets/d/1sAtkjEDh-FTubW0qZHITpee-8Qx-fJbHtqO02-ZIAvA/edit?usp=sharing Easter Eggs 🥚 and bonus useful formulas for the curious inside.

The written tutorial: 🚧Coming Soon: Subscribe to get a notification🚧

The IMPORTRANGE series: https://www.youtube.com/playlist?list=PLSDEbLgMgqvoRJ-e9Sd4UXKxILIQCpzDr

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 FILTER tips:

• Google Sheets: How to use OR inside a FILTER - https://yagisanatode.com/2020/02/15/google-sheets-how-to-use-or-inside-a-filter/
• Google Sheets: Counting and Filtering Rows where Cells Contain Particular Values. - https://yagisanatode.com/2019/10/05/google-sheets-counting-and-filtering-rows-where-cells-contain-particular-values/

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/google-sheets

Grab a Google Sheets Shortcuts Mousepad to help you memorise the Shortcuts. https://www.zazzle.com.au/collections/shortcuts_mousepads-119754792503977450

#GoogleSheets #Spreadsheets #GoogleEdu #administration #GoogleWorkspace ... https://www.youtube.com/watch?v=TrndDSvjs0U