- last edited on
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.
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.
07-06-2018 07:48 AM
You may add helper column to each of your sheets starting from second one, like
if in column A your ID:s (emails), filter that column on TRUE and remove these rows.
07-06-2018 08:04 AMSolution
Maybe try something like this based on the description you've given (See attached .xlsx file for reference):
07-19-2018 07:40 PM
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.
07-20-2018 06:33 AM
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.
11-21-2019 11:44 PM
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
11-22-2019 12:12 AM
What exactly doesn't work?
You generate helper column as in sample, apply filter to it on "Delete Me"
select these two rows, Home->Delete cells and confirm deleting
after clear filter from helper column
and delete helper column if not it's not needed any more.
11-22-2019 02:08 AM
I am almost there.....
I have the three Columns just like yours. How to consolidate the 3 Columns to get Uniformity like yours is where I am stuck then DELETING..... Your assistance will be highly appreciated. Godfrey
11-22-2019 02:52 AM
Sorry let me reexplain again using your 3 columns (A, B and C) that you had sent earlier...
I have been able to achieve Column B and C EXACTLY like yours e.g (Mum@racers.com Column B) and (Delete Me Column C)
However COLUMN A I am unable to MATCH IT to read as Column B Mum@racers.com???
How do I go about it?
Once I succeed Having COLUMN A and B have the same content (firstname.lastname@example.org), I believe it will just be easy to DELETE the rest.
Please advise and thank you in advance for your time and help. Godfrey
11-22-2019 03:14 AM
I hope my above explanation is clear?
What I have currently is as below:
Column A email@example.com Column B firstname.lastname@example.org and Column C Delete Me
email@example.com is a good email. firstname.lastname@example.org is a bad email need to be deleted.
When I looked at your Table you had managed to group good emails together and bad emails together using Delete me and Don't Delete Me.
Mine good and bad are not yet sorted / filtered.
That's where I seek your help?
Should I use SORTING or FILTERING OPTION to get GOOD and BAD emails GROUPED in the right ROW using Delete Me and Don't Delete Me?
Many thnx for you valued time and help God bless you ....
11-22-2019 03:57 AM
11-22-2019 05:25 AM
I have tried several ways but in vain. I was avoiding DELETING EMAILS MANUALLY .... Thanx though for your help. Hope you, myself or the community get a breakthrough on my PENDING ISSUE... Remain blessed....
I believe I have the same need as @AfrikaHub
I couldn't figure out how to attach a file so I just took an example snip. I'm trying to scrub the list of certain zip codes. If the zip code in Sheet1 column I equals 68110 or 68111, I want to remove the row & transfer it to Sheet2.
Is there a formula that can do that?