ExcelBanter - Find duplicates in a column

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Find duplicates in a column (https://www.excelbanter.com/new-users-excel/240349-find-duplicates-column.html)

rock[_2_]

Find duplicates in a column

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

RonaldoOneNil

Find duplicates in a column

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.

"rock" wrote:

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

All times are GMT +1. The time now is 02:34 PM.