Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I find duplicate entries in Excel
I have a list of over 900 names coressponding to other data, but need to know
if there are duplicate names on the list. What should I do? |
#2
|
|||
|
|||
Cher,
Chip Pearson has some stuff on duplicates. www.cpearson.com. -- Earl Kiosterud www.smokeylake.com/ ------------------------------------------- "cher" wrote in message ... I have a list of over 900 names coressponding to other data, but need to know if there are duplicate names on the list. What should I do? |
#3
|
|||
|
|||
if it is in Column a you could add a new column B and enter in B1
=if(Countif(A:A,A1)1,"**","") and copy down to the bottom of your list "cher" wrote: I have a list of over 900 names coressponding to other data, but need to know if there are duplicate names on the list. What should I do? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Find duplicate numbers in large Excel Spreadsheet | Excel Worksheet Functions | |||
In Excel, how do I get rid of duplicate records? Based on text r. | Excel Discussion (Misc queries) | |||
count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
Duplicate records in Excel | Excel Discussion (Misc queries) |