D Dave Peterson Mar 22, 2005 #2 Chip Pearson has tons of ways of working with duplicates at: http://www.cpearson.com/excel/duplicat.htm
Chip Pearson has tons of ways of working with duplicates at: http://www.cpearson.com/excel/duplicat.htm
G Guest Mar 22, 2005 #3 Use the technique here to tag the dupes, then autofilter on the tag and delete the filtered rows http://www.cpearson.com/excel/duplicat.htm#TaggingDuplicates
Use the technique here to tag the dupes, then autofilter on the tag and delete the filtered rows http://www.cpearson.com/excel/duplicat.htm#TaggingDuplicates