Compare two lists in Excel using Power Query @indzara
Compare two lists in Excel using Power Query  @indzara
Uploaded January 2024 | Updated November 2026, 5 days ago
Welcome to the #DatatoDecisions series where we solve common #Excel scenarios while working with #data in Excel, enabling you to get data-driven #decisions from your data.

Working with multiple lists? This video shows you how to compare two lists by using Power Query. You’ll learn how to
1:50 Load the tables into Power Query and then, identify:
3:43 Items that are only in List 1
6:43 Items that are only in List 2
8:23 Items that are on both lists

This extraction comes in handy when you have a list of customers who purchased products A, B and you want to identify those who’ve bought either or both of these products. This knowledge can help you better understand your customers, market products that are popular and much more!

Check our detailed blog posts on our Data to Decisions page:
indzara.com/compare-lists-using-power-query
For tutorials that address common Excel problems, visit indzara.com/datatodecisions

#excelmadeeasy #DatatoDecisions #exceltutorial #listsinexcel #powerquery

***************************************************************************
Check our video on comparing lists using Excel formulas here:
youtu.be/oBivBl5rb18
Compare two lists in Excel using Power QueryHow to Extract Username, Domain, and Extension using Formulas in Excel?Vacation & Attendance Tracker Dashboard in Excel - Ch 3 - Lesson 1 Team Dashboard  Getting StartedHow to Create a Column Chart with Dynamic Number of Columns?MACD Strategy Backtester Template for Google SheetsCreate Columns within a Column Chart in ExcelHow to Create a Waterfall Chart in Excel?Tornado Charts in Excel: For Only Positive Values Explained!Data Extraction and Exploration from a Website using Power QueryData Visualization Toolkit: Instant Chart Maker in Microsoft ExcelExcels IMAGE Function: Mastering the 4 Sizing Options for Perfect VisualsHow to Create an Interactive Line Chart with Dynamic X-Axis?
Indzara - Simple and Effective Templates |

Compare two lists in Excel using Power Query

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER