View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default How to locate duplicate data

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.