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-query-filter-list/ ★ 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: https://twitter.com/exceloffthegrid #MsExcel