Microsoft Excel Tips and Tricks
In this Microsoft Excel video tutorial I explain how to filter a list based on another list. If you are using Excel 365 you can use this combination of functions: XMATCH, ISNUMBER and FILTER. If you have an older version of Excel you can use the Advanced Filter.
Credit Chester Tugwell