Is there a way to automatically delete duplicate entries in Excel.

[NK]

Is there a way to automatically delete duplicate entries in Excel? If there
are Invoice #'s or some other numerical value, can they be deleted or
selected without having to search through the document or filter?

 

[Frank Kabel]

Hi
use 'Data - filter - Advanced Filter' and check 'Unique entries'

 

[Earl Kiosterud]

NK,

Chip Pearson has some techniques that may be useful.
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates
--
Earl Kiosterud
mvpearl omitthisword at verizon period net

President Bush on sovereignty:
http://www.tastefullystated.com/sovereignty.wmv