Howdy group...maybe you can help me?
I've sent a fax to a list of 1,000 companies. I have 'fax numbers only' in a Column in Excel.
I have now been given another list of 2,000 companies to fax to. I have 'fax numbers only' in a different Column in the same Excel spreadsheet.
How do I filter these two lists to ensure that the resulting fax # list does NOT contain any of the original 1,000 list that I faxed to already?
At issue is that this new list of 2,000 fax #'s definitely has some of the same fax #'s as my original 1,000 list.
I'm thinking I need to make an "exclude these #'s" type of filter...and have it scan the new '2,000 list' for any of the old '1,000 list' numbers and have it remove any of those '1,000 list' numbers from the new '2,000 list'...but I have no clue actually...and no clue how to do it.