deleteing duplicates
 

I am working with a large spreadsheet and would like to delete duplicate
names. Is there a way to do this quickly without going through the whole
spreadsheet manually. Thanks

No matter what you do, there will be some manual work involved, but Chip
Peasron's site has some good advice and techniques for finding duplicates

http://www.cpearson.com/excel/duplicat.htm



"syssupspe" wrote:

I am working with a large spreadsheet and would like to delete duplicate
names. Is there a way to do this quickly without going through the whole
spreadsheet manually. Thanks

DataFilterAdvanced Filter.

Check "unique records only" and "copy to another location".

For more on this, including copying to another worksheet see Debra Dalgleish's
site.

http://www.contextures.on.ca/xladvfilter01.html


Gord Dibben Excel MVP

On Wed, 27 Apr 2005 12:33:37 -0700, syssupspe
wrote:

I am working with a large spreadsheet and would like to delete duplicate
names. Is there a way to do this quickly without going through the whole
spreadsheet manually. Thanks