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:
    299
    Likes Received:
    52
    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,520
    Likes Received:
    1,127
    Occupation:
    [email protected]
  3. Nave

    Nave Junior Member

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

    pewep Power Member

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