Extract Customer Names, Not in Master Lists with Advanced Filter – Excel Magic Trick 1598

Download Excel File: https://ift.tt/2ZNsHaA
Learn how to Compare Two Lists and extract customer names that are in List 2 that are not in List 1, The Master List. See the Excel Worksheet Functions: MATCH, ISNA, ISNUMBER and COUNTIFS.

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.