Forum Discussion
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.
tanayprasad Thanks for sharing the detailed steps. Just one correction needed in step 1
Select the cells in both column A and B where you want to see the values that don't match.
Depends on goals. Initial question was "to identify the values in B which are not present in A." If select both columns, that will be unique for this two-columns range. Not values in second column which are not in first columns. Doesn't matter they are duplicated within second column or not.