How to use the FILTER function in Excel to filter a range of data based on criteria you define.

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 …

If the data you want to filter requires complex criteria (such as Type = "Produce" OR Salesperson = "Davolio"), you can use the Advanced Filter dialog box. To open the Advanced Filter dialog …

The FILTER function returns a zero-based array containing subset of a string array based on a specified filter criteria.

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 …

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 …

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 …

Use the AutoFilter to filter a range of data in Excel 2010 and learn how to remove filters.

Point to Number Filters and then click one of the comparison operator commands or click Custom Filter. For example, to filter by a lower and upper number limit, select Between.

In Power Query, you can include or exclude rows according to a specific value. A filtered column contains a small filter icon in the column header.