Filter		Advanced Filter		Pivot Table		Group and Outline		Data Validation		Name Manager
Goal Seek		Freeze Panes		Split Screen		Conditional Formatting		Text to Columns

Advanced Filter

Use Apply Advanced Filter

Unlike Filter, the Advanced Filter feature does not display drop-down lists for the columns.
The criteria range must be specified in a separate range with the same column labels
Click on any cell in the range.
Use Data->Filter->Advanced Filter.
 [Alt]+F+A+A



Filter the list in place
To filter the range by hiding rows that don't match your criteria, click Filter the list, in-place.

Copy to another location

List Range

Criteria Range
Copy to

Unique records only