Скачать с ютуб The FILTER Function in Excel + Bonus Tips - COMPREHENSIVE TUTORIAL! в хорошем качестве

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...   💪🏻 Create a Connected Dot/Dumbbell Chart in Excel    • 💪🏻 Create a Connected Dot/Dumbbell Ch...   ************************************************ 🤝Let's CONNECT on social: ➡️TikTok:   / cellmates_   ➡️Instagram:   / cellmatestr.  . ➡️LinkedIn:   / deborahas.  . ➡️Twitter:   / cellmates_   ➡️Facebook:   / cellmates