4 METHODS to Filter by a List in Power Query | Excel Off The Grid

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


★ Check out the blog post★
https://exceloffthegrid.com/power-que...


★ About this video ★
Filtering is a common task in Power Query, but usually this is based on a single value or a limited number of known values. What happens if we want to be more dynamic? What if we want to base our filter on a list of items? In this video, we show you FOUR methods of doing this.

0:00 Introduction
0:43 Example Data
1:25 Filter by a list
6:30 Merge: a faster alternative
8:06 Filter columns by a list
9:45 Dynamic filtering
12:32 Conclusion

★ 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