Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/duplicat.htm
Neil Davies wrote:
I'm trying to scrub a list of phone numbers (approximately 4000) from old
clients against the National Do Not Call List....
I have my numbers in an excel worksheet, and the DNC numbers in a CSV file.
Is there anyway that I can scrub the list without doing a large number of
=OR( ) functions?
Thanks
--
Dave Peterson