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

nn

Microsoft Excel Tips and Tricks

nIn 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.nnnn

Credit Chester Tugwell

n