Excel 2003

Dan · Jan 30, 2007

is there a function in Excel 2003 that will remove all duplicate entries from
a workbook without having to sort and manually delete?

Gord Dibben · Jan 30, 2007

Dan

Try Advanced Filter steps given here at Debra Dalgleish's site.

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

More at Chip Pearson's site on tagging duplicates for removal.

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

Gord Dibben MS Excel MVP

Chip Pearson · Jan 31, 2007

See http://www.cpearson.com/excel/DeleteDupsWithFilter.htm

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)