Find duplicates in a column

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
 
R

RonaldoOneNil

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding duplicates in column 4
ID inquiry about numbers in column A 4
Data from one file to another 1
find and delte duplicates 2
Add column to file with numbers 4
MS Excel Function (Find Duplicate values) 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
check for duplicates 10

Top