Filter for unique records

Microsoft Office Excel 2003

Filter for unique records

  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.

  4. Select the Unique records only check box.