FInd the duplicate emails

[ramithraov]

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.

[zbor]

You can use =COUNTIF(A:A, A1) to show you how many duplicates there are

You can use =COUNTIF(A:A, A1)>1 for TRUE/FALSE for either new column or conditional formating