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/duplic...gingDuplicates


Gord Dibben MS Excel MVP


On Tue, 30 Jan 2007 12:37:06 -0800, Dan wrote:

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