Remove duplicate entries in Excel

Discussion in 'Windows Desktop Systems' started by ray_gillespie, Mar 24, 2005.

  1. ray_gillespie

    ray_gillespie Moderator Staff Member Political User

    Messages:
    1,692
    Location:
    Birmingham, UK
    Hi,
    I've got an excel spreadsheet full of data that I have compiled from 3 other spreadsheets. A lot of the data in these spreadsheets are present in all 3, so now the one large file I have contains duplications of certain lines.
    Is there anyway to run some sort ot batch process or script that will remove any extra instances of every row of data other than the first occurance of the data in that row?
    Thanks in advance! :)
     
  2. Khayman

    Khayman I'm sorry Hal... Political User Folding Team

    Messages:
    5,518
    Location:
    England
    Highlight the columns, go to data->filter->advanced filter -> tick "unique records only" then with filter inplace or copy to a new location. then you done
     
    ray_gillespie likes this.
  3. ray_gillespie

    ray_gillespie Moderator Staff Member Political User

    Messages:
    1,692
    Location:
    Birmingham, UK
    Sorted! Thanks :)