Results 1 to 5 of 5
  1. #1
    Newbie Affiliate Ian's Avatar
    Join Date
    January 18th, 2005
    ok, i have 2 columns of emails in excel. I want to filter out emails that appear in both colums. How can I do this. Trying not to pull ALL my hair out.

    What if I hav 3 columns, how can I display email addresses that are present in all 3 columns only?

  2. #2
    Full Member
    Join Date
    January 17th, 2005
    Hi Ian

    Do you have access? There is a way to do it in Access...

    Is this urgent? If not I can walk you through it over the phone tomorrow first thing.

    Let me know if I can help you.
    Lizabeth Sorensen
    Affiliate Program Consultant
    518-233-7431 EST.

  3. #3
    Troll Killer and best Snooper!
    I decide when the pigs fly!
    Rhea's Avatar
    Join Date
    January 18th, 2005
    New York, USA
    I've done something similar in Excel but it was several years ago and I don't remember how I did it! lol! (I do remember that it took some fooling around with to get it to work.) So the good news is it is do-able in Excel. The bad news is I can't remember how. Sowwy!

  4. #4
    ABW Ambassador
    Join Date
    January 18th, 2005

    If the first column has 10 in A1-A10 (for example)and column B has any number of items. First, sort the first column alphabetically. Next, in column C, row 1, place the following:


    Then copy this down as far as column B goes. Anything found in column B that also appears in column A will show a blank...anything in column B that doesn't appear in column A will show up in column C.

    Then copy column C and paste special (only values) in the same place. Sort column C, then copy and paste onto the end of column A.

  5. #5
    Newbie Affiliate Ian's Avatar
    Join Date
    January 18th, 2005
    Hi Wyvern,

    Can't get that formula to work. I will keep trying to night.

    Lizabeth: PM on it's way! Thank you!

  6. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. G Mail Filtering
    By daiarian in forum Midnight Cafe'
    Replies: 9
    Last Post: October 9th, 2013, 10:11 AM
  2. Duplicate Emails
    By Uncle Rico in forum ShareASale - SAS
    Replies: 27
    Last Post: December 12th, 2008, 01:19 PM
  3. filtering for my merchants
    By jazzylee77 in forum PopShops
    Replies: 12
    Last Post: March 31st, 2008, 09:29 PM
  4. international filtering
    By breeze in forum Midnight Cafe'
    Replies: 4
    Last Post: December 2nd, 2004, 08:44 AM
  5. Multiple Duplicate Emails From Merchants
    By ~Michelle in forum Commission Junction - CJ
    Replies: 2
    Last Post: December 10th, 2003, 05:25 AM

Posting Permissions

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