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 …
FILTER function - Microsoft Support
How to use the FILTER function in Excel to filter a range of data based on criteria you define.
Quick start: Filter data by using an AutoFilter - Microsoft Support
With filtering, you can control not only what you want to see, but what you want to exclude. You can filter based on choices you make from a list, or you can create specific filters to focus on exactly the data …
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 …
Filter by using advanced criteria - Microsoft Support
To filter the list range by hiding rows that don't match your criteria, click Filter the list, in-place.
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 …
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. …
Dynamic list filtering - Microsoft Support
With dynamic filtering, you can filter one list based on a selection made in another list. In the following example, the Marketing Documents library is filtered by a selection in the Project Information list.
Use slicers to filter data - Microsoft Support
Slicers provide buttons that you can click to filter tables, or PivotTables. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is …
Filter for or remove duplicate values - Microsoft Support
When you filter for unique values, you temporarily hide duplicate values, but when you remove duplicate values, you permanently delete duplicate values. A duplicate value is one where all values in the row …
Using Advanced Filters in Excel 2010 - Microsoft Support
We'll walk you through the Filtering process using this small database: Note: Ensure that AutoFilter is off and there is always a blank row and column separating your database from any other text on the …