Hi Everyone,
I am new to excel, I have two excel sheets x and y, I need to find out the duplicates, so I have copied the emails from and x and y and made a new excel sheet z so now I have col A and col B just emails and i have selected both and sorted them in order, now I want to know if there are any duplicates in both the columns how can i do that either it should display duplicates or colour duplicates or true or false which ever easy that helps the separated data any one please help me

Cheers,
Ramith.