Using the Remove Duplicates command


show more Using the Remove Duplicates command provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010 show less
please wait ...

Using the Remove Duplicates command

Getting rid of duplicate records in a database, or a large list, addresses a problem that occurs frequently in large lists of data. Finally, as of Excel 2007, a new command called Remove Duplicates is now available on the Data tab. In large lists sometimes you don't see duplicates that easily. I happen to see one here in Row 5. That's Juan Bishop. Here is another Juan Bishop here in Row 10. Now, the names being the same alone isn't enough to indicate that the record is duplicated, but a quick look here, I think you can see pretty clearly with Social Security number's and phone number's duplicated. That's a duplicate record.

Now, in prior versions of Excel, you needed to use something called the Advanced Filter. But with this new capability-- and by the way, the data does not have to be in any particular order. It doesn't have to be sorted here. We can remove duplicates relatively quickly. In this list here, I am going to double- click the bottom edge of a cell f...

Using the Remove Duplicates command
Video duration: 2m 30s 1h 32m Appropriate for all

Viewers:

Using the Remove Duplicates command provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010

Subjects:
Business IT
Software:
Excel
Author:
please wait ...