Need to scrub a phone list with the Do Not Call List

Hi Guys,

I'm not very good with Excel and need some help. Is there an easy way to take a list of phone numbers or contacts that are on the Do Not Call List and scrub them against another list? Ideally the DNC numbers/contacts will be removed from the new list.

Thank you for your help!

Thanks for the quick response. Can you please give me more instructions how to filter and what goes where? I opened the file and I see Column A has 1-100 and then Column B says DNC on several rows. Do I past my new list in section A. Then my DNC numbers in Section B. Then do something? I'm good at many programs but have never done much with Excel. Thank again!

I figured out what i was doing wrong and see how the system works now. I needed to use the page tabs below... The issues I'm having is that when I change out the 2 digit numbers with 7 digit phone number, it doesn't work any longer to find the number. It also doesn't work when I ad more than 100 rows. What do you think I'm missing? Thanks again!

Originally Posted by popipipo

Are both list really all numbers or is one off them text?

Both list are text of just 7 digit phone numbers.