+ Reply to Thread
Results 1 to 9 of 9

Filtering out unsubscribe emails? Merging and Deleting?

  1. #1
    Registered User
    Join Date
    03-20-2016
    Location
    Sydney
    MS-Off Ver
    Mac, 2016
    Posts
    3

    Exclamation Filtering out unsubscribe emails? Merging and Deleting?

    Hi!
    I have a spreadsheet (A) that has 7000 email addresses in it.
    I have another spreadsheet (B) that has 500 emails in it - these ones are "unsubscribes".

    I am trying to merge the two and delete the emails from the (A) 7000 list.

    Apart from finding and deleting each individual email from the 7000 list, is there any way I can somehow merge and delete the two?

    Ultimately I will end up with a list that has 6500 entries.

    Any help would be greatly appreciated!

  2. #2
    Registered User
    Join Date
    09-24-2015
    Location
    Delhi, India
    MS-Off Ver
    MS Office 2013
    Posts
    65

    Re: Filtering out unsubscribe emails? Merging and Deleting?

    hi skip007,

    can you upload sample workbook.

    Thanks
    Rohit

  3. #3
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Perth Western Australia
    MS-Off Ver
    Office 365
    Posts
    257

    Re: Filtering out unsubscribe emails? Merging and Deleting?

    Try adding a column in sheet a with the formula Countif(sheetA!b1:b500,+A1) then filter a delete any result >1 in sheet A.

  4. #4
    Registered User
    Join Date
    03-20-2016
    Location
    Sydney
    MS-Off Ver
    Mac, 2016
    Posts
    3

    Re: Filtering out unsubscribe emails? Merging and Deleting?

    Hi! Can you just confirm this for me? (sorry..not an excel pro!).

    One Spreadsheet.
    Column A has the 7000.
    Column B has the 500.

    excel.jpg

    So you're saying add a column C and put the formula: Countif(sheetA!b1:b500,+A1) in a cell?

    Please clarify for me! Many thanks!

  5. #5
    Registered User
    Join Date
    09-24-2015
    Location
    Delhi, India
    MS-Off Ver
    MS Office 2013
    Posts
    65

    Re: Filtering out unsubscribe emails? Merging and Deleting?

    hi Skip007,

    if you have data in column A(7000) and Column B(500). simple add a column between column A and column B. use vlookup for match the email id.

    Thanks
    Rohit

  6. #6
    Registered User
    Join Date
    09-24-2015
    Location
    Delhi, India
    MS-Off Ver
    MS Office 2013
    Posts
    65

    Re: Filtering out unsubscribe emails? Merging and Deleting?

    hi Skip007,

    after adding new column between A and B. use this in column B.

    Please Login or Register  to view this content.
    Thanks
    Rohit

  7. #7
    Registered User
    Join Date
    03-20-2016
    Location
    Sydney
    MS-Off Ver
    Mac, 2016
    Posts
    3

    Re: Filtering out unsubscribe emails? Merging and Deleting?

    Hi Rohit_Raj,

    Thanks that worked! In column B I now have the values that have been duplicated.

    excel-2.jpg

    Now how do I remove them from Column A?

    Thanks!

  8. #8
    Registered User
    Join Date
    09-24-2015
    Location
    Delhi, India
    MS-Off Ver
    MS Office 2013
    Posts
    65

    Re: Filtering out unsubscribe emails? Merging and Deleting?

    hi Skip007,

    it will better to you that putt both data in different sheet. in sheet1 colunm A(7000) and sheet2 column A(5000).

    on sheet1 put this formula in columnB2. and copy paste till the end.

    Please Login or Register  to view this content.
    then filter sheet1 and short column B(A to Z). then u can delete all row which is match easily.
    Thanks
    Rohit

  9. #9
    Forum Contributor
    Join Date
    10-29-2014
    Location
    udaipur, rajasthan
    MS-Off Ver
    2007
    Posts
    343

    Re: Filtering out unsubscribe emails? Merging and Deleting?

    Quote Originally Posted by Skip007 View Post
    Hi Rohit_Raj,

    Thanks that worked! In column B I now have the values that have been duplicated.

    Attachment 451923

    Now how do I remove them from Column A?

    Thanks!
    for removing duplicate... just select whole column and then home tab ---------data------remove duplicates ---ok---ok
    If answer helped you say Thanks by Add Reputation

+ 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. Replies: 2
    Last Post: 01-13-2016, 05:41 AM
  2. Opening emails and deleting rows
    By amartino44 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2013, 03:32 PM
  3. [SOLVED] Merging data while deleting duplicates?
    By kosmoscake in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-16-2012, 02:48 PM
  4. text file merging and filtering using macro's
    By scambug in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-08-2012, 06:04 AM
  5. [SOLVED] deleting vs. filtering . . . HELP!
    By Wayne Knazek in forum Excel General
    Replies: 10
    Last Post: 07-25-2006, 07:45 PM
  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