Having difficulty using advanced filter

[tuccokeith]

Hello,

I am trying to use the advanced filter to only display unique records in a column.

What are the correct steps to use an advanced filter to select only unique records?

 

[KenWright]

Select advanced filter, choose 'copy to another location' and check the 'unique values only box. You can see a guide to using AF at the following link:-

http://www.contextures.com/xladvfilter01.html#FilterUR

Exact steps as listed on Debra's site are as follows:-

Select a cell in the database.
From the Data menu, choose Filter, Advanced Filter.
Choose 'Copy to another location'.
For the List range, select the column(s) from which you want to extract the unique values.
Leave the Criteria Range blank.
Select a starting cell for the Copy to location.
Add a check mark to the Unique records only box.
Click OK.

Link will give you a piccy as well though.

Regards
Ken..........