Hi,

I know I have seen this formula before, but I cannot for the life of me find it or remember it and hoping someone here can help. I will explain what I need the best I can.

I have column A with emails that I have listed as "Bad" or "don't send" and I have pasted in Column B a new list of emails that I want to send out, but I need to make sure none of the emails in column A are in the list of Column B. so what I am looking for is for Column B, new emails, be compared against master email list in Column A and put net results in Column C. That way I can then use those emails and not worry that I would send another email to someone that has unsubscribed.

Column A = Master Unsubscribed List of Emails

Column B = New email list I want to send out

Column C = Net new email list making sure no emails from column B are in Column A.

Thanks for your help!