Forum Discussion

Niraj1's avatar
Niraj1
Copper Contributor
Jul 27, 2023

Excel Compare two columns to find unmatched values

I want to compare two columns (A and B) and want to identify the values in B which are not present in A. 
Formulas and Functions
tanayprasad's avatar
tanayprasad
Brass Contributor
Jul 27, 2023

Niraj1 

You can easily achieve this using Conditional Formatting-

  1. Select the cells in column B where you want to see the values that don't match.
  2. Go to the "Home" tab in the Excel ribbon.
  3. In the "Styles" section, select "Conditional Formatting".
  4. Select "Highlight Cells Rules".
  5. Then choose "Duplicate Values."
  6. In the "Duplicate Values" dialog box, select "Unique" from the dropdown list.
  7. Choose a format (e.g., fill color) for highlighting the unmatched values, and click "OK."

If you have any doubts, please let me know. 

Aman2119's avatar
Aman2119
Copper Contributor
Jul 11, 2024
Thank you tanayprasad. Niraj1 

But this will only give unique valves in the same column (column B). 

I have same query, where i want to compare two columns A & B which might have duplicate values but I only want to filter out (identify) the unique values of column B which are not present in column A.

Thank you

Resources