Posts by Mattman

    Thanks everyone!

    I got it working...using Domenic's formula...took me a bit to figure out that I had to 'type it out', couldn't just copy it and CTL, SHFT, ENTER...

    Thanks so much group for your help and ideas...I'm sure they'd ALL have worked if I was competent enough to figure out how to implement them and make them work! :)

    Take care,

    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. :)

    Any ideas?
    Matthew Miller
    [email protected]