You can use the techniques on Chip Pearson's site, to mark and delete
the duplicates in the source data:
http://www.cpearson.com/excel/duplicat.htm
Tony wrote:
Does anyone know of an easy way to use excel to scrub information against
another excel list?
I have a list of numbers in a excel page (spread out over 4 colums) and need
to see if any of these numbers are listed in a different database.
Any suggestions?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html