Excel is has 100s of functions, but my absolute favourite has to be the FILTER function. It let's you filter a dataset based on conditions. This makes the job of data analysis and calculating summaries so much easier. You can create any type of complex criteria with FILTER function to simplify your job.

In this video 💡⏱👉
================
0:00 - Introduction to FILTER function with simple examples
1:41 - Understanding the spill range & FILTER output
2:46 - Printing just the names, not all data
4:07 - Count of FILTER results (using # operator)
5:02 - AND condition with FILTER
7:30 - OR condition, filtering data that meets any condition
9:42 - NOT condition with Excel FILTER function
11:53 - Implementing a complex business situation with FILTER
14:48 - What if there is an ERROR?
15:28 - Next steps

Sample file & article 📗📃👉
=======================

Download the sample data & formula workbook from here - https://chandoo.org/wp/wp-content/upl...
Refer to this page for a detailed article on NEW Excel functions - https://chandoo.org/wp/dynamic-array-...

➕More Advanced Excel functions 👉
===============================

Want to learn advanced formulas & functions with Excel? Check out below videos next.

I don't use VLOOKUP either -    • I don't use VLOOKUP anymore. I use th...  
15 Essential Formulas for Data Analysis -    • These are the ONLY 15 functions you n...  
A quick overview of all Dynamic array functions in Excel -    • Learn about the *NEW* Dynamic Array F...  
Advanced IF formula examples -    • 10 Advanced IF formulas every analyst...  
Advanced SUMIFS / COUNTIFS examples -    • 10 *next level* SUMIFS tricks only Ex...  
Advanced VLOOKUP tricks -    • 5 *Advanced* lookup tricks that Data ...  

1️⃣👉 My Skillshare course on Advanced Lookups & more - https://skl.sh/3hbR49d

Camera crew 🙍‍♀️🎥:
================
Jo, my wife. Chan2 is not real. 🤣


#Filter #ExcelTips #Chan2