View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default how do i scrub two list for any matches in excel?

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