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 …

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

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

Nov 1, 2025 · Learn about types of filters for reports in Power BI, including the page filter, the visualization filter, and the report filter.

Aug 21, 2025 · I have a large data base. In column A I have a group number. These group numbers repeat multiple times though through out the sheet and within each group there is deferent 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 …

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 …