Comparing two cells in a colum with 2000 rows

T

thomas1075

I have created a mailing list with app. 2000 email addresses in Excel
and I would like to check if I have doublets without having to sort the
column alphabetically and look for doublets myself. Can I use some kind
of function in Excel that compare two cells throughout the columns?
 
D

Domenic

Assuming that Column A contains your list, try the following...

B1, copied down:

=IF(COUNTIF($A$1:$A$2000,A1)>1,"Duplicate","")

Hope this helps!
 
P

Piranha

thomas1075 said:
I have created a mailing list with app. 2000 email addresses in Exce
and I would like to check if I have doublets without having to sort th
column alphabetically and look for doublets myself. Can I use some kin
of function in Excel that compare two cells throughout the columns?
Click to expand...
Assuming that Column A contains your list, try the following...

B1, copied down:

=IF(COUNTIF($A$1:$A$2000,A1)>1,"Duplicate","")

Hope this helps!
Click to expand...
Will do the same as Domenic's except it won't tag the first occuranc
of the
duplicate entry.
Put in B1 - Copied down

=IF(COUNTIF($A$1:A1,A1)>1,"Duplicate","")

Thx
Dav
 
Top