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 either reapply a …

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

If you can’t find specific data in a worksheet, it may be hidden by a filter. For example, if you have a column of dates in your worksheet, that column may have a filter that restricts the values to specific …

To enable or disable web and search filters, turn the Filter inappropriate websites and searches toggle on or off. To block or add specific sites, add their URLs under Blocked Sites or Allowed sites.

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 …

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 …

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.

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

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 …

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 …