Removing duplicate values

As your company grows, you've probably found that one of the most common…problems in maintaining good data hygiene is identifying and eliminating…duplicate values from a data list.…In this movie I will show you how to quickly and easily remove duplicate values…from a data list, but also give you some warnings about how it can affect…your data and why you should never remove duplicates on your only copy of a data list.…As my sample file I will use Duplicates, which you can find in the Chapter 6…folder of your Exercise Files archive.…

This file contains a simple data list. One of those names, Steven Ng, occurs twice,…and you'll notice that there are two individuals named Curt.…Let's say that I want to remove duplicate values in this list.…To do that I just click any cell in the list, as I have already done, and then…on the Data tab, click Remove Duplicates.…In the Remove Duplicates dialog box, I can identify the columns that need to…match for a duplicate to be identified and removed.…So you can see that Excel properly identified the entire list. It has also…