Skip to main content

Compare 2 Lists in Excel [Fast method]

This video is also available on my YouTube channel:

I am going to explain you how to compare two lists in excel. This is in my opinion the quickest and easiest way to do it.


So as you see here we have grocery list 1 and grocery list 2. We will start by selecting the first list then we hold the ctr key while selecting the second list.

Now go to the home tab. Click on conditional formatting. Choose highlight cell rules. Then select duplicate values.


A new window will appear. Now we have to make a decision. We can either choose to highlight the duplicate values or to highlight the unique values. For the purpose of this tutorial we will select the option duplicate values. Now press Ok.

So that’s all you have to do. As you will see, excel has highlighted all duplicate values with a red color.


Leave a Reply

%d bloggers like this: