Uploaded December 2023 | Updated September 2026, 2 weeks ago
This video from our “Data to Decision” series is for lists in Excel.
A common need while using Excel lists is to compare the elements or the items that are present in one list with another.
This video will make working with Lists a lot simpler for you! You’ll learn how to compare:
2:50 Items that are only on one list
6:52 Items that are on both lists
Where do we use this in real life?
– Consider you have lists of customers who purchased products A and B. Comparing these lists to get the list of customers interested in both your products.
– Another example would be in the reconciliation of financial statements. Here, identifying the list of transactions from only one system or those from both systems is a very common use case.
Functions you'll learn through this: MATCH, FILTER, ISNA, UNIQUE, ISNUMBER
Check our detailed blog posts on our Data to Decisions page:
indzara.com/compare-lists-using-formulas-in-excel
To explore our fast-growing collection of free Excel tutorials covering a wide array of topics, please visit: indzara.com/datatodecisions
#exceltips #excelmadeeasy #exceltutorials
If you have any alternative methods for list comparison, please share your thoughts in the comments below.
This video from our “Data to Decision” series is for lists in Excel.
A common need while using Excel lists is to compare the elements or the items that are present in one list with another.
This video will make working with Lists a lot simpler for you! You’ll learn how to compare:
2:50 Items that are only on one list
6:52 Items that are on both lists
Where do we use this in real life?
– Consider you have lists of customers who purchased products A and B. Comparing these lists to get the list of customers interested in both your products.
– Another example would be in the reconciliation of financial statements. Here, identifying the list of transactions from only one system or those from both systems is a very common use case.
Functions you'll learn through this: MATCH, FILTER, ISNA, UNIQUE, ISNUMBER
Check our detailed blog posts on our Data to Decisions page:
indzara.com/compare-lists-using-formulas-in-excel
To explore our fast-growing collection of free Excel tutorials covering a wide array of topics, please visit: indzara.com/datatodecisions
#exceltips #excelmadeeasy #exceltutorials
If you have any alternative methods for list comparison, please share your thoughts in the comments below.
