Excel’s Ultimate FILTER Hack - Multiple Columns, Multiple Values 😲
Sign up for our free Insiders program and get the example file:
Click here: https://exceloffthegrid.com/insiders/
File Reference for this video: 0265 Flexible Filter.
★ Want to become an Excel ninja? Check out our training academy ★
https://exceloffthegrid.com/
★ About this video ★
Filtering in Excel is often limited by rigid drop-downs or predefined criteria. This video shows you how to break that limitation by creating a flexible filter that works with multiple columns and multiple search values.
It’s all standard Excel formulas—no VBA required.
We walk through each step clearly, so you can replicate the technique in your own files. By the end, you’ll have a robust filter that’s easy to maintain and extend as your data changes.
00:00 Introduction
00:16 Scenario
01:00 Splitting the search terms
01:35 The date value problem
03:17 Combine columns
05:00 Checking for search terms
07:42 Applying the FILTER
08:22 Testing
08:54 Filter All
9:48 Flexible Filter Function
12:00 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