Re: Excel Compare two columns to find unmatched values

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