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 FormatConditional 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
"Robin Rescue" <Robin
wrote in message
...
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.