Excel 2003
 

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

Excel 2003
 

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?

Excel 2003
 

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)


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