Find duplicates in a column

  • Thread starter Thread starter rock
  • Start date Start date
R

rock

Hi,

I have 6000 emails addresses in a col and wish to know if there are any
duplicates.

How can I do this please.

I have Excel 2002.

rock
 
Assuming your emails are in A1 to A6000, in B1 enter
=COUNTIF($A$1:$A$6000,A1)
copy down B1 all the way to B6000
Apply a conditional format of red pattern on cells B1 to B6000 where Cell is
greater than 1 and all duplicates will be shown in red.
 
Back
Top