When you need to find the
unique entries in an Excel list, the quickest way to locate them is with the Advanced
Filter. For example, you have a list of homes sold by date and location. You
would like to see a listing of the cities where the homes were sold. Because
you sold multiple in homes in a number of cities, the data in the City column
contains a number of duplicates. To produce a city list without duplicates,
follow these steps:

  1. Select the City column.
  2. Go to Filter | Advanced Filter.
  3. Click in the Copy
    To Another Location text box, then click on a cell in
    the same worksheet where you want to locate the new list.
  4. Click the Unique
    Records check box.
  5. Click OK.

Excel will list the unique
values found in the City column at the designated location.

Miss a tip?

Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.

Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.