In Excel, how do I remove everything in column A that also appears in column B?

M

misstinabunni

New member
Joined
Mar 19, 2009
Messages
2
Reaction score
0
Points
1
If column A is "e-mail addresses we have for customers" and column B is "e-mail addresses we know are bad." How do I filter for items that are ONLY in list A so that we end up with a list of only good e-mail addresses?
I already tried "unique results only" but that's not what I need. "Remove duplicates" only removes the second instance and I need to remove both instances.
 
Back
Top