Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to remove duplicates from a list and copy new list to new colu | Excel Worksheet Functions | |||
Help with Highlighting all duplicates in a row | Excel Discussion (Misc queries) | |||
How to indentify duplicates in a "Self Populating" field? | Excel Discussion (Misc queries) | |||
Finding Duplicates | Excel Worksheet Functions | |||
removing duplicates testing in 2 coloms | Excel Worksheet Functions |