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.
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
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
