The New Filter Function in Excel
In this video, I want to introduce the FILTER function to you. But in the video, we will go way beyond a simple introduction. We will show how to simulate AND and OR. And in the end, we will create a nested FILTER function that will enable us to dynamically pick the column we want to FILTER by and the COlumns we want (or don't want) to see within the result. The FILTER function is truly one of the best new dynamic array functions, and everyone should start using it today!
You can download the file I used in this video here: https://excelolympics.com/wp-content/...
Links to blog posts and videos that are relevant:
Filter Function (Excel Unplugged (by Alan Murray)) - https://excelunplugged.com/2019/09/10...
Introduction to Dynamic Array Functions: • Dynamic Arrays Introduction
Chapters:
0:00 Intro
0:08 Introduction to the video
0:40 Simple example and the CALC Error
2:04 UNIQUE, Data Validation, and FILTER
3:25 Multiple Conditions (AND and OR) with the FILTER function
7:13 FILTER Function - Choose Columns for the Result and Choose the Filter Column
9:04 Nested FILTER functions - Subset of Columns
14:40 SORT not SORTBY
15:47 Conclusion
16:20 Outro
Gear Used:
US Links
Camera: Canon EOS R6 - https://amzn.to/3e9zxML
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/3tYd37w
Audio converter: Zoom UAC-2 - https://amzn.to/3dgM8wS
Laptop: Dell XPS 15 - https://amzn.to/3w8CyoK
Lights: Elgato Key Light - https://amzn.to/3rurte7
EU Links
Camera: Canon EOS R6 - https://amzn.to/3tubwGy
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/32pi2m0
Audio converter: Zoom UAC-2 - https://amzn.to/3amDRXP
Laptop: Dell XPS 15 - https://amzn.to/3effMmT
Lights: Elgato Key Light - https://amzn.to/3vcs6v9
Green Screen (visible in bloopers): https://amzn.to/3ajUm6Y
Recorded With: Camtasia - https://www.techsmith.com/video-edito...
Subscribe for more Excel tutorials on the Excel Olympics YouTube Channel: http://bit.ly/EOYTsub
Subscribe to the Excel Olympics Newsletter: https://bit.ly/3w3rkjK
Disclaimer: Some links included in this description might be affiliate links. If you purchase a product or service with the links that I provide, I may receive a small commission with NO additional charge to you! I appreciate your support!
#Excel #ExcelOlympics #gasperkamensek