I don’t use filters in Excel anymore. I use this other function instead 😎

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/uploads/2021/09/filter-examples.xlsx Refer to this page for a detailed article on NEW Excel functions - https://chandoo.org/wp/dynamic-array-functions/ ➕More Advanced Excel functions 👉 =============================== Want to learn advanced formulas & functions with Excel? Check out below videos next. I don't use VLOOKUP either - https://youtu.be/DDlZXXEI1bU 15 Essential Formulas for Data Analysis - https://youtu.be/B5hayFelHDU A quick overview of all Dynamic array functions in Excel - https://youtu.be/ONaS7IMKJPM Advanced IF formula examples - https://youtu.be/-yFpzIRifK4 Advanced SUMIFS / COUNTIFS examples - https://youtu.be/YEt-aYbDTrs Advanced VLOOKUP tricks - https://youtu.be/240fbiyFFKI 1️⃣👉 My Skillshare course on Advanced Lookups & more - https://skl.sh/3hbR49d Camera crew 🙍‍♀️🎥: ================ Jo, my wife. Chan2 is not real. 🤣 #Filter #ExcelTips #Chan2