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 📗📃👉
=======================

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

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

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

#Filter #ExcelTips #Chan2

[patrickschardt]

Humor and knowledge. The best kind of learning

[mbadri]

The problems that you had provided as exercises were very tricky and it really helped me to understand the filters more deeply. Thanks a lot!

[dokudowiec]

You just made my day, pal. I was working on Sunday to catch up with my project. Had enough, opened a beer and came across your channel. I don't think you have included this in your video, but if you reference cell, with filter formula in conditional formatting plus # it will create dynamic dropdown menu. HOW AWSOME IS THAT. I will have to redo all may workbooks! God job man!!! You have a new subscriber!!!

[bin-naya]

Chandooo you are EXCEL GURU I swear u are so good in formulars, best teachers in YouTube

[prodig]

I showed this to my Boss now he is my new intern 😎😎

thanks chandoo ☺️❤️

[lilianezeli]

Chandoo I hope you're having an amazing day wherever you are. I wish you many more happy moments. Your videos have really made me improve my excel skills in just a week. My own way of supporting this channel is to not skip any ads.

[vaijayantigulve]

I think you are by far the best teacher I ve come accross for Excel. Thank you for all the knowledge. You are doing a great job. Keep it up.

[nudger]

Thank you Chandoo, A well presented and paced video covering some fairly advanced topics. 👍

[eniale]

Excellent video! Very helpful and love the flow of the tutorial. Makes it easy to follow and understand 👏🏼

[TheAkashchitnis]

The # is a life saver for dynamic selection. I have struggled with this in the past. Thank you for the great video.

[peterlarsen]

Thank you Chandoo. I find your way of teaching really easy to understand and also really useful for my work. I really appreciate the effort you put into your videos.

[Marie-ntin]

Geez, a complete unknown formula for me! Great comprehensive and funny video! Can’t wait to be next morning to try this on my spreadsheets! Thank you for the discovery 😍

[eduarchavarria]

Very useful, thanks. I see many similarities between the FILTER function arguments and the array formulas for counting and summing.

[thexrman]

This is an amazing tutorial; filled with detailed questions, in a simple way, with a sense of humor - love it!

[MultiJess]

Thankyou Chandoo. I used to dread filtering the data and copy-pasting it onto a separate sheet. This is really helpful!

[elphasluyuku]

Im so happy i came across this channel. Chandoo has me feeling unstoppable. You are the GOAT!

[sairakhan]

Thank u chandoo for this amazing tutorial.I have made a report by using your array formulas unique and countif in ten minutes

[Levince]

Thanks to your video, I also find out we can use SUMPRODUCT to sum all values in case of displaying filtered data and get the sum at the same time.

[vijayarjunwadkar]

Thank you Chandoo (and of course Chan2)! All doubts about FILTER function are indeed filtered now! Keep it up! 😊👍

[luizklebermarinho]

As ALWAYS, Chandoo being the BEST! For Excel tips and Power BI tips, Chandoo is great. Thank you very much Chandoo for sharing knowledge