How to locate duplicate data

R

Robin Rescue

I have a spreadsheet of about 14,000 lines. Four Columns (A) First Name, (B)
Last Name, (C) Login and (D) Email Address. I need to find out if any of
these contacts have the same email address.
 
T

T. Valko

You can use conditional formatting to highlight any duplicates.

I'll assume the email addresses are in the range D1:D14000

Select the range D1:D14000
Goto Format>Conditional Formatting
Formula Is:

=COUNTIF(D$1:D$14000,D1)>0

Click the Format button
Select the Pattern tab
Set the fill color to light yellow (?)
OK out

Biff
 
Top