Microsoft Office Tutorials and References
In Depth Information
Excel provides many tools for managing long lists.
With such lists, you may find you need to identify and
display unique records. A baseball-card collector, for
example, may want to find the number of unique
players represented in his collection so he can create
a catalog. Alternatively, a store manager may want to
know the number of unique individuals represented in
her survey to help her make informed decisions about
Excel provides tools for displaying only unique
records in a list. Start with a worksheet formatted as
a list in which some of the records are duplicates,
meaning the values in every column are the same.
Use Excel’s advanced filtering tools to identify and
remove from view the duplicated records. Ordinarily,
you use advanced filtering tools to create filters in
several columns or even several filters on a single
If you want to remove duplicate records permanently,
use the Remove Duplicates option on the Data tab.
Click in a cell in your list.
Click the Data tab.
l The Advanced Filter dialog box
Click Filter the List, In Place
Click and drag to select your
entire list, or type the cell range.
Click Unique Records Only