Using the Advanced Filter to create unique lists from repeating field data


show more Using the Advanced Filter to create unique lists from repeating field data 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 Advanced Filter to create unique lists from repeating field data

A not so obvious capability of using the Advanced Filter is the idea of creating a unique list. Now sometimes you might do this even for a single column. There are about 700 or so here. We might want a unique list of the departments. Obviously we see recurring entries here. We might have that need. More expansive is the idea that maybe you got duplicate records in here. There are a couple right here. Do we have others? No we don't know necessarily and if so, where are they? Let's get rid of them.

We are not going to be using the new feature called Remove Duplicates, although that's certainly an option. But let's talk about the idea that we can use the Advanced Filter to create a new list that does not have duplicates. How many records are here? I am going to double-click the bottom edge of this cell. We see that it goes down the row 762. Let's create a new list using the Advanced Filter. We are going to put that list off to the right here. We want to compare its results...

Using the Advanced Filter to create unique lists from repeating field data
Video duration: 3m 15s 1h 32m Appropriate for all

Viewers:

Using the Advanced Filter to create unique lists from repeating field data 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 ...