+ Reply to Thread
Results 1 to 3 of 3

Have an email list of 300K, an unsubscribe list of 100K, need to make a new list of ???K

  1. #1
    Registered User
    Join Date
    05-28-2013
    Location
    Los Angels
    MS-Off Ver
    Excell 2011
    Posts
    1

    Exclamation Have an email list of 300K, an unsubscribe list of 100K, need to make a new list of ???K

    Are you an excel wizard??? I need your magic! I am by no means anything CLOSE to an excel wizard. I don't know how to do formulas, etc, and am mainly looking to see if there is some form of Macro / automated process in doing this. I work for a small start-up company where we all wear a dozen hats and it has been delegated to me to figure this out, and my internet searching lead me to this forum!

    I have two huge email lists. We're talking just over 300k

    1 email address list is a list of people who have unsubscribed from a mailing list. Let's call this list A which has about 100k folks.

    The second list is a big list (300k) that I need to make sure that if an address exists in list A, it needs to be removed. Let's call this list B.

    I need to make a NEW list, which we'll call list C. List "C" will be a safe list if you will, meaning we took list "A" and cross-referenced it against list "B", and as long as list "A" didn't unsubscribe from list "B", we can stick them in the safe list "C".

    Make sense? I know that there are excel wizards who will see this and say "no problem", put in a simple formula and render this out in a few minutes.

    Let me know if you have any further questions! Thank you. Need this done sooner than later =)

    PS- It really surprises me that there isn't a simple place to go online to upload two .csv's / excel workbooks and have it spit out a rendered sheet at the click of a few buttons.

    Thank you!


    ~Nick

  2. #2
    Registered User
    Join Date
    05-15-2013
    Location
    Hyderabad
    MS-Off Ver
    Excel 2003
    Posts
    39

    Re: Have an email list of 300K, an unsubscribe list of 100K, need to make a new list of ??

    Hi Nick,
    I suppose the attached spread sheet works for you,
    You need to updated all your list in the respective headers as mentioned and you can get the safe list in the c column all you need to do is filter the c column with not blanks and use the list.

    Lemme knw if this do not work for you,
    may be i ll try some other stuff for ya..

    [Code]=IF(VLOOKUP(B2,A:A,1,0)=B2,"",VLOOKUP(B2,A:A,1,0))[\code]




    Column A with Unscribed Mailing List,
    Coulmn B with Complete Email List
    and Column C sa Safe Mailing List.

    In C Column use this formula til end of the sheet and you should get your requirement in the same column



    Cheers lol

  3. #3
    Registered User
    Join Date
    02-22-2015
    Location
    Singapore
    MS-Off Ver
    2010
    Posts
    1

    Re: Have an email list of 300K, an unsubscribe list of 100K, need to make a new list of ??

    can I have this file please? i need similar help

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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