filtering account numbers from a worksheet

[fouraker]

I'm new to excel. I have created a spreadsheet containing my newspaper's
subscriber list, containing account numbers and addresses. I want to merge
another list of subscribers(with account numbers and addresses) with the
first list to scrub those addresses, etc. from that list. Can anyone advise
me?

 

[Frank Kabel]

Hi
not completely sure what you're trying to do. But as a starting point:
http://www.cpearson.com/excel/duplicat.htm#InOneNotOther
http://www.cpearson.com/excel/duplicat.htm#ExtractingCommon