Filtering IMPORTRANGE data in Google Sheets with FILTER

The starter sheet: https://docs.google.com/spreadsheets/d/1sAtkjEDh-FTubW0qZHITpee-8Qx-fJbHtqO02-ZIAvA/copy Easter Eggs 🥚 and bonus useful formulas for the curious inside. The written tutorial: https://yagisanatode.com/2022/05/11/filtering-importrange-data-in-google-sheets/ 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 QUERY tips: - How to get the most frequently appearing words in a column with QUERY - https://yagisanatode.com/2021/10/19/how-to-get-the-most-frequently-appearing-words-in-a-column-in-google-sheets/#The_QUERY_solution - 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