Removing duplicates


show more Removing duplicates provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

Removing duplicates

How often have you spent hours looking through lists of data looking for duplicates. Just to make sure that the information that you're working with is clean as clean can be. Well, no need to do that any longer. Now we have a command called remove duplicates that will allow you to do this very, very quickly. Open up the worksheet for StoreA to follow along. First thing you want to do is you want make sure you're looking at the Data tab, because that's where the Remove Duplicates commande is sitting. Once you've gotten there, the next thing you want to make sure is that you've selected your whole table to work with. And how do you know you've got your whole table? Well if you scroll through this particular worksheet, and you come down to the rows 25, 26 and 27; you'll notice a couple of things. Visually, you'll notice that you're shading--your mixed shading--has stopped.

Row 26 should be shaded a little bit as should row 28, but it seems to have stopped t...

Removing duplicates
Video duration: 4m 1s 5h 13m Beginner

Viewers:

Removing duplicates provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...