Find Matches in Two Lists (Extract Matches AUTOMATICALLY) 🔍🪄

In Excel, find matches in two lists and extract them automatically with array formulas. In Microsoft Excel 365, extract matches between two lists with array formulas such as FILTER and COUNTIFS easily. Learn more than 150 of the best Excel functions with 'Advanced Excel Formulas' https://amzn.to/3Rg87Go It is common to need to compare two lists and match values, and I'm created many Excel tutorials on this over the years. This video shows a great dynamic and automatic reporting solution. 00:00 Introduction 00:45 Find matches in two lists with COUNTIFS 01:24 FILTER for matched values 02:38 Sort the matched values 03:01 Extract the unmatched values in two lists Find more great free tutorials at; https://www.computergaga.com Connect with us! LinkedIn ► https://www.linkedin.com/in/alanmurray-computergaga/ Instagram ► https://www.instagram.com/computergaga1/