Рет қаралды 659,047
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 - chandoo.org/wp/wp-content/upl...
Refer to this page for a detailed article on NEW Excel functions - 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 an...
15 Essential Formulas for Data Analysis - • These are the ONLY 15 ...
A quick overview of all Dynamic array functions in Excel - • Learn about the *NEW* ...
Advanced IF formula examples - • 10 Advanced IF formula...
Advanced SUMIFS / COUNTIFS examples - • 10 *next level* SUMIFS...
Advanced VLOOKUP tricks - • 5 *Advanced* lookup tr...
1️⃣👉 My Skillshare course on Advanced Lookups & more - skl.sh/3hbR49d
Camera crew 🙍♀️🎥:
================
Jo, my wife. Chan2 is not real. 🤣
#Filter #ExcelTips #Chan2