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.
Access the Google Form to submit ideas and questions for future videos here: [ Ссылка ]
Download the tutorial workbook here: [ Ссылка ]
▬ 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!
