Forum Discussion
Solved
How to delete specific email ids from MS Excel 2007.
I have 1 list of unsubscribe email ids and lots of lists of subscribers. I want to remove emails contained in Unsubscribed list from all of my Subscribed list. Is there any formula/option/sorting...
Maybe try something like this based on the description you've given (See attached .xlsx file for reference):
Maybe try something like this based on the description you've given (See attached .xlsx file for reference):
I am unable to get results. It showed some emails in Column A but those are not from Column B. Kindly explain more on the issue.
Can you please provide some kind of non-sensitive sample mockup file for the community to test their solutions on? The formula I provided should contain a text string in Column C (not an email) indicating whether you need to delete the value in Column A. Then you can just filter on Column C and delete the emails in the filter, leaving only the emails that you do not wish to delete.