Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel qustion - Deleting Duplicates

  • 15-11-2006 11:24am
    #1
    Zascar
    Moderators, Motoring & Transport Moderators, Music Moderators Posts: 12,781 Mod ✭✭✭✭


    I have an excel sheet with one column and about 600 rows, however most of them are duplicates and there are only about 80 actual unique entries.

    Is there a way to delete the duplicates automatically so I just have the 80 unique rows - at the moment I'm doing it manually and its a pain the the ar$e...


Comments

  • #2
    kippy
    Registered Users, Registered Users 2 Posts: 18,984 ✭✭✭✭kippy


    Highlight the column of duplicates.
    Data, Filter, Advanced filter, Tick Unique records only. Hit okay.
    Should do the job for you. (You may get a warning about excel not being able to determine the row but it's okay to press okay to this.)
    Kippy


  • #3
    Zascar
    Moderators, Motoring & Transport Moderators, Music Moderators Posts: 12,781 Mod ✭✭✭✭Zascar


    Legend, thanks.
    Record timing too!


  • #4
    Gordon
    Registered Users, Registered Users 2 Posts: 35,524 ✭✭✭✭Gordon


    Cool! I used to sort them all and then put an if statement:
    if the cell above is equal to this cell then output "Woah duplicate!" else output "Cool!". Then sort by that column and delete everything else.

    Never even glanced at filter, cheers.


  • #5
    kippy
    Registered Users, Registered Users 2 Posts: 18,984 ✭✭✭✭kippy


    http://www.meadinkent.co.uk/xldropdown.htm

    Try use google for stuff like this, theres tonnes of info up there.
    Kippy


Advertisement