How to Compare Two Lists in Microsoft Excel

Microsoft Excel offers two different methods to help you compare two lists and highlight the missing items in each one. You can choose to highlight the missing items in both lists or in a single one. I’ll show you how.


Chapters:
0:00 Intro
0:23 The Quick Way: Highlight Unique Cells to Compare Lists
1:09 The Formula Way: Use Conditional Formatting to Compare Lists
2:16 End screen



What you will learn:
1. The Quick Way: Highlight Unique Cells to Compare Lists
a. How to use Excel’s unique highlight feature
b. How to choose how you would like to highlight the missing items
c. How to make missing items highlighted
2. The Formula Way: Use Conditional Formatting to Compare Lists
a. How to highlight missing items in a specific list
b. How to use a formula with conditional formatting
c. How to assigns a unique name to your range of cells
d. How to refer all cells to a single name
e. How to specify how your missing items will be highlighted
f. How to format the missing items in your list
3. How to quickly perform a comparison of two different lists in your Excel spreadsheets
4. How to Compare Two Columns in Microsoft Excel
















Song: Hotham – Home
Music provided by Vlog No Copyright Music.
Creative Commons – Attribution 3.0 Unported
Video Link: https://youtu.be/6Up4530QqZg

#computereverywhere #howto #compare #list #microsoftexcel