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
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










