Forum Discussion
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/filter through which i can directly remove emails contained sheet A from emails list of Sheet 1, Sheet 2 and further from all sheets.
or
If i paste Unsubscribed email ids in column B of all of my subscribed sheets and want to remove those emails from Column A if any contains.
Maybe try something like this based on the description you've given (See attached .xlsx file for reference):
14 Replies
Maybe try something like this based on the description you've given (See attached .xlsx file for reference):
Hi Matt, it worked very well. Thank you :)
Thank you Matt and Pooja for these contribution though I am following the steps but it hasn't worked for me. Kindly provide clear STEPS. Thank you in advance awaiting your swift respone... Godfrey
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.
Hi,
You may add helper column to each of your sheets starting from second one, like
=(COUNTIF(Sheet1!A:A,A1)>0)
if in column A your ID:s (emails), filter that column on TRUE and remove these rows.
