Elimintating Duplicates?

[CindyC]

Hi,

Does anyone know how to eliminate duplicates in an excel sheet? I am
analyzing data on Doctors names but many of the names are listed more
than once so I can't get an accurate count of distinct names help?

 

[Guest]

Cind

See if you can find your answer her
http://cpearson.com/excel/duplicat.ht

If not, there are numerous duplicate Q&As on this usergroup. Just type in duplicate or duplicate, excel in your search. Then start reading.

Stev

----- CindyC wrote: ----

Hi

Does anyone know how to eliminate duplicates in an excel sheet? I a
analyzing data on Doctors names but many of the names are listed mor
than once so I can't get an accurate count of distinct names help

 

[Gord Dibben]

Cindy

You can use Data>Filter>Advanced Filter.

"Copy to a new location" and "Unique records only"

Filtering Tutorial at Debra Dalgleish's site.......
http://www.contextures.on.ca/tiptech.html

More on Duplicates marking, preventing at Chip Pearson's site....
http://www.cpearson.com/excel/topic.htm

Scroll down to "D" section and select Duplicate topics.

Gord Dibben Excel MVP

 

[JMay]

To get a Unique Count enter:

=SUM(1/COUNTIF(A3:A12,A3:A12)) << change range to suit your needs

but instead of pressing the enter key press Control+Shift+Enter
(the method for entering a control array, which it is)
should look like this afterwards:

{=SUM(1/COUNTIF(A3:A12,A3:A12))}

displaying the unique number of doctors.
HTH

 

[marco]

Hi,

Does anyone know how to eliminate duplicates in an excel sheet? I am
analyzing data on Doctors names but many of the names are listed more
than once so I can't get an accurate count of distinct names help?

1. sort your sheet (suppose your unique key is in column A and your
data starting at line 2)
2. add a column on the right of your data(let's say D)
3. insert "=A2=A1" in D2
4. copy down D2 (columns to eliminate will display TRUE)
5. select entire D column, copy, paste special with Values Only option
6. sort on D
7. delete all TRUE lines

if your key is more than a column or the entire line you can either
insert an A column with the concatenation of all values in the line or
replace the "=A2=A1" with "=AND(A1=A2,B1=B2,....)"

Bye
Marco