Apologies if this has been asked before: there are numerous 'remove duplicates in Excel' questions, but I can't seem to find one that matches my exact problem.
I have two columns of customer e-mail addresses in Excel - one is a national list of about 8000, the other is localised, about 500. I'd like to remove the localised entries from the national list to avoid spamming the local recipients. How can I do this quickly?
(I am using the latest version of Excel)