Next level FILTER Function tricks | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★

★ Get the example file ★
Sign up for our free Insiders program and get the example file:

★ 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 ★

★ Where to find Excel Off The Grid ★

#MsExcel

[ExcelOffTheGrid]

Sign up for our free Insiders program and get the example file:
File Reference for this video: 0214 FILTER function tricks

[arteogr]

Thank you so much for the solution to filter based on another list, I spent 3 hours to meet you 🙂

[excelgazialimuhiddinhacibekir]

HATS OFF to Excel OFF the Grid! Much, but very very much appreciated, Mark! You are absolutely a genius! It is so hard to thank you enough!

[ymup]

Oh I think the slicer one with LAMBDA is going to help with what I'm trying to do at work!

[colinekszczecin]

Filtering based on a list will be a big game changer for me, thank you very much for this video

[IvanCortinas_ES]

Excellent video Mark. As always, going a little deeper, where others don't go. Very professional. Thank you so much.

[kndeepak]

Ridiculously easy to understand!! Outstanding as usual

[martyc]

Brilliant Mark- I’ve seen all of these before but not all in the one place- great Video

[oxnardmontalvo]

I feel I got a lot smarter, althoug I only understood about 40% of it on the first watch. excellent video!

[cherianiype]

one of the best videos on FILTER... thank you very much Mark! Cherian in Abu Dhabi!

[sherryfox]

@MMark, outstanding! My favorite is Ex8 Filter/Choose specific columns. Thanks for sharing!!!!

[rajrawat]

Watched Best video On FILTER functions ever.Thank you for Your Contribution to our Success

[noelgreen]

Brillant explanation as always. Have been using this function since its release, but learn a lot from your logical process steps. Thanks a lot.

[UtuDudas]

For filtering by a list, I recommend ISNUMBER with XMATCH. It works better because you can use it inside of LET. XMATCH can use arrays only whereas COUNTIF/S needs at least a range to work.

[hsilva]

Thank you for this very useful video, the way you explain is very easy to understand it.

[alexrosen]

One of the best tutorials I have seen so far on the filter function 👌

[silvanodemetrio]

Awesome. I've been looking for "filter" functions examples and that's the best one. Great video!!!!

[williamarthur]

Really like the return all option, also the use of choosecols, I still head straight to index or worse offset for a lot of things where these 'newer' funcs could be used.

[daleanderson]

That was great, thanks. What a powerful function!

[stevemorris]

Good roundup and a couple of new tricks for me :)

Ctrl + Enter keeps the current cell selected so you don't have to leep moving up again