1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

I need help on excel

Discussion in 'BlackHat Lounge' started by rap8557, Jul 23, 2013.

  1. rap8557

    rap8557 Jr. VIP Jr. VIP

    Joined:
    Sep 15, 2008
    Messages:
    1,331
    Likes Received:
    480
    How can i do this?
    View attachment 34727

    Col A would be my Master List of Emails
    Col B would be the New Harvested Emails
    Col C would Check the Master List if the new harvested emails has duplicates on the master list and get only the unique ones.

    Thanks
     
  2. Conor

    Conor Elite Member

    Joined:
    Nov 7, 2012
    Messages:
    3,577
    Likes Received:
    5,955
    Gender:
    Male
    Location:
    South Africa
    Home Page:
    Put them all in one column, and use the "Check for duplicates" feature in Excel. It will delete any duplicates in your list.

    PS: My goodness you have a lot of thanks ^^
     
  3. rap8557

    rap8557 Jr. VIP Jr. VIP

    Joined:
    Sep 15, 2008
    Messages:
    1,331
    Likes Received:
    480
    I want the duplicated stuff also deleted. the function remove duplicate will just remove the duplicate i need both of them to be removed.
    PS: Cool huh! :D that makes me unique!
     
  4. blackhat777

    blackhat777 Elite Member

    Joined:
    Jun 25, 2011
    Messages:
    1,784
    Likes Received:
    653
    Learn vlookup and you should be fine.
    Search online, there are a lot of tutorials.