« Libby App from OverDrive | Main | Calling all Techies! »

Removing duplicates in Excel, again

We've covered a couple of ways to remove duplicates from Excel before, but those methods destroyed the original data.  If you wanted to keep the original data, you needed to save a copy of it somewhere first.  There's a way to filter out the duplicates which leaves the original data in place and has you save the de-duplicated information in another location instead. 

  1. Open the file in Excel and elect the information you'd like de-duplicated.  Note: If you don't have a header on your column, Excel will complain about the missing column header.
    Selectaddresses

  2. Click on the Data tab (1) at the top of page and, in the Sort and Filter section, click on Advanced (2).
    Datafilter

  3. An Advanced Filter window will appear.  Since we're wanting to keep the original list, click on "Copy to another location" and click on the button at the right hand side of the "Copy to:" field.
    Filterwithcopy

  4. This brings up a small "Advanced Filter - Copy..." window.  Chose the column you wish to have the new list copied to and then click on the icon at the end of the field. 
    Filterlocation

  5. You'll be back at the "Advanced Filter" window.  Check the "Unique records only" box and click on OK.
    Filterwithcopy2
  6. You now have a new list with the duplicates removed but your original list is still intact.    
    Nodups

Comments

Feed You can follow this conversation by subscribing to the comment feed for this post.

Post a comment