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.

Select OK. Filter by using date/time filters You can filter by date/time value using the Date/Time Filters submenu. To open a query, locate one previously loaded from the Power Query Editor, select a cell …

Overview of advanced filter criteria Advanced Filter works differently from Filter in several important ways. It displays the Advanced Filter dialog box instead of the AutoFilter menu. You create a criteria …

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 …

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. …

To filter data, the workbook author must remove these nonprinting characters or replace them with a printing character. Calculated members in PivotTable reports You cannot apply a filter that combines …

In the following worksheet, a filter is available for the Product column, but it hasn’t been used. The filter in the Country column has been used to sort the data. Remove all the filters in a worksheet If you …

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