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):
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.