+ Reply to Thread
Results 1 to 4 of 4

Looking To Remove Specific Emails (700+) from Larger List.. HALP! ;c)

  1. #1
    Registered User
    Join Date
    05-22-2009
    Location
    Southampton, NY
    MS-Off Ver
    Excel 2003
    Posts
    29

    Looking To Remove Specific Emails (700+) from Larger List.. HALP! ;c)

    I'd imagine this is going to be a popular one, if not already. However, I do not even know the correct terminology to search for in terms of trying to find the answer to my question...

    Ok, so here's the deal....

    I recently started email campaigns, and I want a way to quickly remove specific emails from larger lists. I have 5500+ emails, from which I want to remove 700+ names. I'd imagine 'Remove Duplicates' would not work, as I don't just want the duplicate removed, I want the original removed, as well.

    I messed around quickly by highlighting duplicates, and sorting by cell color.... However, it appears there are still some glitches (random non-highlighted cell amongst a column of highlights, also does not expand to other rows, etc) so I'd imagine there is a better way.

    Also, I still have to go through and manually delete any addresses that were highlighted. Not a huge deal, but does get quite annoying with the sporadic misplaced cells....

    What is the quickest way for me to take care of this?

    Thanks for the help in advance!!!!

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Looking To Remove Specific Emails (700+) from Larger List.. HALP! ;c)

    Do you have a list of the emails your want removed?
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    05-22-2009
    Location
    Southampton, NY
    MS-Off Ver
    Excel 2003
    Posts
    29

    Re: Looking To Remove Specific Emails (700+) from Larger List.. HALP! ;c)

    Mike, thanks very much for the response! I actually finally found the 'unopened' option for exporting from mailchimp. It's hidden, but I found it. Thanks though. I'm assuming it's probably not worth the hassle in trying to find out how to do this? Although it might come in handy down the line for someone, I'm sure.

  4. #4
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Looking To Remove Specific Emails (700+) from Larger List.. HALP! ;c)

    Unfortunately I cant help much without a sample data set and some sort of LIST or LOGIC into how to remove particular items from your data.

+ 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. [SOLVED] Remove a List of Persons from a Larger List
    By criticalslinky in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 01-10-2024, 02:47 PM
  2. [SOLVED] Finding a specific list of names inside larger list
    By Boxed in forum Excel General
    Replies: 7
    Last Post: 09-13-2013, 06:46 PM
  3. HALP! Count and Insert Rows and Specific Data on Another Sheet.
    By goradiar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2012, 08:00 AM
  4. How do I remove duplicate emails from a list?
    By fastrack1 in forum Excel General
    Replies: 2
    Last Post: 01-21-2010, 10:31 PM
  5. Cross ref. emails from small list with a larger list?
    By DiscoStu in forum Excel General
    Replies: 2
    Last Post: 09-27-2007, 07:21 PM

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