Filter for unique records

Try Office 2010 In Excel 2010, you can easily find unique records and remove duplicate values.
Watch a video or try Office 2010!

By enabling filtering and applying a filter to one or more columns of data, you can return the rows of data on your worksheet that meet the conditions you specify.

  1. Select the column or click a cell in the range or list you want to filter.
  2. On the Data menu, point to Filter, and then click Advanced Filter.
  3. Do one of the following.
    • To filter the range or list in place, similar to using AutoFilter, click Filter the list, in-place.
    • To copy the results of the filter to another location, click Copy to another location. Then, in the Copy To box, enter a cell reference.

To select a cell, click Collapse Dialog Button image to temporarily hide the dialog box. Select the cell on the worksheet, and then press Expand Dialog Button image.

  1. Select the Unique records only check box.

 Note    Once you filter for unique values, you can copy them to another worksheet and then archive or delete the original worksheet.

Applies to:
Excel 2003