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 Premium Member

    Joined:
    Sep 15, 2008
    Messages:
    1,083
    Likes Received:
    436
    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 Jr. VIP Jr. VIP

    Joined:
    Nov 7, 2012
    Messages:
    3,358
    Likes Received:
    5,420
    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 Premium Member

    Joined:
    Sep 15, 2008
    Messages:
    1,083
    Likes Received:
    436
    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,779
    Likes Received:
    653
    Learn vlookup and you should be fine.
    Search online, there are a lot of tutorials.