Site icon Top News Today

Excel Filter List Based on Another List | Formula and Advanced Filter Solutions

Excel Filter List Based on Another List | Formula and Advanced Filter Solutions
YouTube video player

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

Exit mobile version