Next level FILTER Function tricks | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy

★ Get the example file ★
Sign up for our free Insiders program and get the example file:
https://exceloffthegrid.com/insiders-...
File Reference for this video: 0214 FILTER function tricks.zip

★ About this video ★
This video includes amazing FILTER function tricks that you can use to take your spreadsheets beyond the next level.

INCLUDES:
0:00 Introduction
0:17 FILTER Recap
1:42 Multiple Conditions
3:01 If_empty Array
3:52 Partial Match
5:06 Based on List
6:10 Using Slicers
8:15 Automate Excel
8:40 Show All Items
10:03 Specific Columns
11:04 User Column Selection
12:00 Dependent Drop Down
13:09 Wrap-up

★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/

★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter:   / exceloffthegrid  

#MsExcel