Using excel to "scrub" lists
 

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?

Using excel to "scrub" lists
 

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