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

Find duplicates in excel

Discussion in 'BlackHat Lounge' started by jopagi, Jan 18, 2017.

  1. jopagi

    jopagi Jr. VIP Jr. VIP

    Joined:
    Oct 25, 2013
    Messages:
    278
    Likes Received:
    51
    Gender:
    Male
    Location:
    R'lyeh
    Hi, i've three list of hundreds keywords on excel, i need to check and find any duplicates in them, i don't know any function that work for this and do it manually will take me hours, do you know how i can proceed?
     
  2. virtualbyron

    virtualbyron Jr. VIP Jr. VIP

    Joined:
    May 11, 2014
    Messages:
    1,298
    Likes Received:
    830
    Occupation:
    WHITE HAT
    Home Page:
  3. Nave

    Nave Junior Member

    Joined:
    Nov 13, 2016
    Messages:
    120
    Likes Received:
    31
    Gender:
    Male
    Excel file -> Data -> Remove duplicates
     
  4. pewep

    pewep Power Member

    Joined:
    Nov 3, 2008
    Messages:
    660
    Likes Received:
    2,896
    Gender:
    Male
    Occupation:
    Yogi-In-Training
    Location:
    U.S.
    csved