The Advanced Filter allows you to filter unique records and copy them to another location outside the data set. This is useful when you want to use a filtered list for further analysis.
This can also be achieved by using a Pivot Table. Placing a Field in the Row Labels will show unique values. From there you can copy and paste outside the Pivot Table.