Filter by using advanced criteria - Microsoft Support
It displays the Advanced Filter dialog box instead of the AutoFilter menu. You type the advanced criteria in a separate criteria range on the worksheet and above the range of cells or table that you want to …
Filter data in a range or table in Excel - Microsoft Support
Use AutoFilter or built-in comparison operators like "greater than" and "top 10" in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can either reapply a …
Using Advanced Filters in Excel 2010 - Microsoft Support
The Advanced Filter gives you the flexibility to extract your records to another location on the same worksheet or another worksheet in your workbook. It also allows the use of an "OR" statement in …
FILTER function - Microsoft Support
How to use the FILTER function in Excel to filter a range of data based on criteria you define.
Filter for or remove duplicate values - Microsoft Support
You can filter for unique values to temporarily hide duplicate values, and you can remove duplicate values to permanently delete duplicate values. A duplicate value is one where all values in the row …
Filter data in a workbook in the browser - Microsoft Support
Filtering data is a quick and easy way to create a subset of data in a range of cells or in a table column. Filtered data displays only the rows that meet criteria that you specify and hides rows that you do not …
Reapply a filter and sort, or clear a filter - Microsoft Support
After you have filtered or sorted data in a range of cells or table column, you can either reapply a filter or perform a sort operation to get up-to-date results, or you can clear a filter to redisplay all the data.
Filter for unique values or remove duplicate values
To filter for unique values, select Data > Sort & Filter > Advanced. To remove duplicate values, select Data > Data Tools > Remove Duplicates. To highlight unique or duplicate values, from the Home tab, …
Use AutoFilter to filter your data - Microsoft Support
Use AutoFilter to find values, or to show or hide values, in one or more columns of data. You can filter values based on choices you make from a list, or search to find the data that you want to see. When …
Count unique values among duplicates - Microsoft Support
Count the number of unique values by using a filter You can use the Advanced Filter dialog box to extract the unique values from a column of data and paste them to a new location. Then you can use …
Filter data in a query - Microsoft Support
These filters make it easier to filter for a range of values, rather than selecting all the values individually. All filters are automatically cleared when you close the query. Or, you can clear a filter from a column …