| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I find duplicates in one column of an exel spreadsheet? | Excel Worksheet Functions | |||
| Find Duplicates | Excel Discussion (Misc queries) | |||
| compare data in column A with column B to find duplicates | Excel Discussion (Misc queries) | |||
| How to find duplicates within same column | New Users to Excel | |||
| Find Duplicates | Excel Discussion (Misc queries) | |||
![rock[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
