+ Reply to Thread
Results 1 to 8 of 8

how do you unsubscribe in bulk?

  1. #1
    Forum Contributor
    Join Date
    12-10-2012
    Location
    Petalu
    MS-Off Ver
    Excel 2010
    Posts
    124

    how do you unsubscribe in bulk?

    I'm hoping I could get some quick help on a problem I need solved. Thanks in advance for your advice. I have attached a spreadsheet. On the data tab I have a list of contacts. On the sample there are just 3, on the actual spreadsheet there are hundreds of entries. I also have an unsubscribe tab with a list of emails that I need to remove from the data tab. What I would like to do is have all the emails from the unsubscribe tab delete the entire matching row on the data tab? Make sense? So I would like the entire entry on the data tab deleted. Can that be done?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: how do you unsubscribe in bulk?

    f2 =IFERROR(IF(MATCH($C2,unsubscribe!$A$1:$A$11,0)>=1,"delete",""),"") and drag down.

    after that filter on column F on the word delete and delete those rows.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Contributor
    Join Date
    12-10-2012
    Location
    Petalu
    MS-Off Ver
    Excel 2010
    Posts
    124

    Re: how do you unsubscribe in bulk?

    thanks, makes sense but when I do that I get no matches

  4. #4
    Forum Contributor
    Join Date
    12-10-2012
    Location
    Petalu
    MS-Off Ver
    Excel 2010
    Posts
    124

    Re: how do you unsubscribe in bulk?

    oh i got it now, thanks!

  5. #5
    Forum Contributor
    Join Date
    12-10-2012
    Location
    Petalu
    MS-Off Ver
    Excel 2010
    Posts
    124

    Re: how do you unsubscribe in bulk?

    it only got about half the entries, if I manually copy and past the emails from the unsubscribe tab I am still finding entries in the C column of the data tab.

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: how do you unsubscribe in bulk?

    post your excel file, with your failures. Please add manualy the expected result in your file.

    Edit:

    Did you changed the range?

    unsubscribe!$A$1:$A$11
    Last edited by oeldere; 09-13-2017 at 03:00 PM. Reason: edit

  7. #7
    Forum Contributor
    Join Date
    12-10-2012
    Location
    Petalu
    MS-Off Ver
    Excel 2010
    Posts
    124

    Re: how do you unsubscribe in bulk?

    oh that's it the range...sorry!

  8. #8
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: how do you unsubscribe in bulk?

    You're welcome. We appreciate the feedback!

    If your question has been solved please mark the thread as being solved.

    In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

    It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Unsubscribe/delete account
    By bellflower in forum Suggestions for Improvement
    Replies: 4
    Last Post: 11-08-2016, 02:47 AM
  2. Replies: 8
    Last Post: 03-20-2016, 03:43 AM
  3. Replies: 2
    Last Post: 02-22-2015, 11:40 AM
  4. Transpose in bulk
    By Daisy10 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-27-2008, 02:26 AM
  5. Bulk Upload
    By Kris in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2006, 10:20 AM
  6. OT: How to UNsubscribe from forum?
    By karatelovr in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-20-2005, 03:12 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1