How to Identify Differences Between 2 Columns in Excel Without Formula

If you are trying to compare data between 2 columns and want to identify the differences, there is a simple way to do that in Excel. Comparison of data between columns can be quite handy for various reasons, including reconciliation of information and identifying different values.

Steps for Comparing Data Between 2 Columns in Excel

Step 1: Select the columns you want to compare

step 1 select columns

Step 2: From Home Tab, click on Conditional Formatting > Highlight Cell Rules > Duplicate Values

step 2 conditional formatting

Step 3: Select either Duplicate or Unique values from the dropdown.

step 3 choose duplicate or unique values

Duplicate values will highlight values which are the same between the two columns while unique values will highlight data which is different between the two columns.

Leave a Comment

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.

Scroll to Top
Scroll to Top