How to cross reference 2 lists in 2 separate columns in excel.
Posted on 2016-10-27
I have a list that is in this format in column A1 in excel 2010:
Allow, *@mxtoolbox.com, *
Allow, *@amazon.com, *
Allow, *@flip.com, *
Allow, *@demo.com, *
Allow, *@gmail.com, *
Allow, *@yahoo.com, *
I want to be able to remove the entire line in Column A1 (or just delete the cell) if it matches a domain name in column B1 which is a list of domain names as such:
Can someone help me understand how i could achieve this?