Skip to content

Find Unique Values Between Two Lists

Let’s say that you have two lists of data that appear to be the same, but you’re not sure.

Your goal is to see what the differences are between the two lists. In other words, you want to locate the unique values.

This article will show you how to find the unique values within seconds.

Step 1 – Select Both Lists

The first step is very simple. Select the first list range, and then hold the CTRL key to select the second list range as well.

With both list ranges selected, you can move to step two.

Step 2 – Add Conditional Formatting

The next step is to go to Conditional Formatting > Highlight Cell Rules > Duplicate Values.

In the dialog box that appears, change Duplicate to Unique, and then click on Ok.

Excel will then highlight the unique values, and your quest to see the differences between the two lists is complete.

It’s really as easy as one, two, and done!

See It In Action

Check out the video below to see how it’s done.

This Post Has One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top