Duplicate entries

[okie11]

is there a way to delete multiple duplicate entries in excel spread sheets with out having to do them individually. using the find and replace feature takes to long.

 

[Debra Dalgleish]

Chip Pearson has instructions for tagging duplicate entries in a list:

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

After you've tagged them, use an AutoFilter (Data>Filter>AutoFilter) to
display only the tagged rows, then select and delete them.