The FILTER Function in Excel + Bonus Tips - COMPREHENSIVE TUTORIAL!
The FILTER Function in Microsoft Excel is possibly MY FAVOURITE function in Excel. It's DEFINITELY my favorite Dynamic Array Function!
Available in Excel 365 and Excel 2021, this little function allows us to filter a dataset and place the results anywhere in the workbook. And, because it is a formula, we can combine it with other functions like SORT, SORTBY, COUNTIF etc. to create more complex formulas.
In this video, we are going to walk through the following:
FILTER Function Basics
FILTER with AND (*) Criteria
FILTER with OR (+) Criteria
FILTER with One or the Other but not Both (-) Criteria
FILTER with Both or Neither (=) Criteria
FILTER Non-Adjacent Columns
Using FILTER to Compare Lists
********************************
Chapters
00:00 - 01:00 - Introduction
01:00 - 07:52 - FILTER Function Basics
07:52 - 10:05 - The FILTER Function with AND (*) Criteria
10:05 - 11:57 - The FILTER Function with OR (+) Criteria
11:57 - 14:33 - The FILTER Function with One or the Other but Not Both (-) Criteria
14:33 - 16:16 - The FILTER Function with Both or Neither (=) Criteria
16:16 - 17:01 - FILTER and SORT
17:01 - 21:34 - FILTER Non-Adjacent Columns
21:34 - 23:31 - Compare Lists with FILTER, COUNTIF and NOT
23:31 - 23:41 - Outro/Close
********************************
DOWNLOAD THE WORKBOOK
🔗https://www.cellmatestraining.com/dow...
********************************
🔗LINKS to related videos
📈Create Pivot Table Report Filter Pages
• 📈Create Pivot Table Report Filter Pages
🤔NEW Excel GROUPBY Function - How does it work?
• NEW Excel GROUPBY Function - How does it w...
💪🏻 Create a Connected Dot/Dumbbell Chart in Excel
• 💪🏻 Create a Connected Dot/Dumbbell Chart i...
************************************************
🤝Let's CONNECT on social:
➡️TikTok: / cellmates_
➡️Instagram: / cellmatestr. .
➡️LinkedIn: / deborahas. .
➡️Twitter: / cellmates_
➡️Facebook: / cellmates
Auf dieser Seite können Sie das Online-Video The FILTER Function in Excel + Bonus Tips - COMPREHENSIVE TUTORIAL! mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Cellmates 13 August 2024 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 44,769 Mal angesehen und es wurde von 1.3 tausend den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
