In this video, we use Power Query to compare two lists in Excel. We look at three different ways to compare the lists for matches and differences.
Master Everything in Excel today - bit.ly/UltimateExcel
The video will walk you through loading the lists as connections and then producing results using different join types.
Find more great free tutorials at;
computergaga.com
*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ► bit.ly/UltimateExcel
Excel VBA for Beginners ► bit.ly/37XSKfZ
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm
Connect with us!
LinkedIn ► linkedin.com/company/18737946/
Instagram ► instagram.com/computergaga1/
Twitter ► twitter.com/computergaga1
- Compare Two Lists in Excel using Power Query ( Download)
- Compare Two Columns with Microsoft Excel Power Query | Excel Formula Hacks ( Download)
- Easily Compare Multiple Tables in Power Query ( Download)
- Easily Compare Two Tables in Power Query ( Download)
- Best Way to Find the Difference Between 2 Large Lists | Excel Power Query ( Download)
- Compare two lists in Excel using Power Query ( Download)
- Excel PowerQuery: Match multiple columns between two tables ( Download)
- Compare Two Lists and Find Matches & Differences with 1 Formula - Excel Magic Trick ( Download)
- Master Excel 2024: Advanced Pivot Table Functions, Power Pivot Tools, and Data Modeling Essentials ( Download)
- Compare Tables for Unmatched Records in Excel with Power Query ( Download)
- Compare Two Lists, Extract Customers Not in Both: Excel Formulas or Power Query; EMT 1811 ( Download)
- Compare Two Lists the Right Way ( Download)
- Comparing Two Lists in Excel with Functions - all Power Query Merge Joins - T0033 ( Download)
- Extract Customer Names, Not in Master Lists with Power Query - Excel Magic Trick 1599 ( Download)
- Excel Formula to Compare Two Lists - Excel Magic Trick 1596. Is Item in List ( Download)
