Excel's FILTER function - The Definitive Guide

In this video I share EVERYTHING you need to know about Excel's FILTER function. I also share a more advanced use case that can be used for reporting information from any table with multiple parameters like class, dates and anything in between.

▬ Contents of this video ▬▬▬▬▬▬▬▬▬▬

0:00 - Intro
0:24 - The inspiration behind this video
0:58 - The basics
1:34 - Advanced use case introduction (continued)
2:19 - The basics (continued)
3:20 - Range and Array explained
4:15 - The "include" parameter explained
4:50 - AND (*) and OR (+) operators
5:22 - [if_empty] explained
6:05 - Examples intro
6:45 - Example 1 - Sales above 3800 sorted
8:43 - Example 2 - AND operator
11:55 - Example 3 - OR operator
13:07 - Advanced include parameters
13:39 - In-depth formula review
14:08 - The maths behind the OR parameter
14:40 - The maths behind the AND parameter
15:28 - Advanced use case tutorial
19:33 - Data validation from a dynamic array named range
20:58 - Outro

Thanks for watching.
Please LIKE, SUBSCRIBE and leave a COMMENT!

[nsanch]

Thank you for the great filter videos. I like how you wrote out the include parentheses to make the formula more clear ()+().

[rajeshjawajala]

Dear Renier, thanks a lot for sharing/creating a very informative video in a very simple & easy way to grasp te concept. please keep doing more such interesting videos related to Excel, I'm already a subscriber to your channel from India. Best luck & wishes

[BezUmiaru]

Great! Suggestion for next video: is there a way to filter a table’s column based on typed-in text in e.g. a cell above

[bashbash]

Hi, Im looking for a filter that will enable me to find specific text or letters in 2 or 3 columns, and sort by countries.
Thank you so much, I’ll try to work with your formulas