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