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

Finding duplicates in an excel sheet

Discussion in 'Windows & Other Software' started by The_KiD, 2 May 2006.

  1. The_KiD

    PermaBanned

    Joined: 19 Apr 2006

    Posts: 2,342

    Location: West Yorkshire

    Right I have an excel sheet, which is one column with a load of web addresses in.

    Is there anything I can run or do to automatically run through it and remove any duplicate's ?
     
  2. div0

    Mobster

    Joined: 12 Jan 2006

    Posts: 3,600

    Location: Edinburgh

    Select the column - click Data - Filter - Advanced Filter - (make sure selected range highlighted is correct) - click "unique records only"

    Done :)
     
  3. The_KiD

    PermaBanned

    Joined: 19 Apr 2006

    Posts: 2,342

    Location: West Yorkshire

    dude I love you :)
     
  4. div0

    Mobster

    Joined: 12 Jan 2006

    Posts: 3,600

    Location: Edinburgh

    sssshhh dont tell everyone ;)





    they'll get jealous :D