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.

Feb 24, 2026 · Learn how to use filters in the Power BI service to view and analyze specific data in your reports.

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 …

If the data you want to filter requires criteria across multiple fields, such as filtering by multiple conditions that must all be true, or showing rows that match any of several different conditions (such as Type = …

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

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

Apr 25, 2024 · You can use FILTER to reduce the number of rows in the table that you are working with, and use only specific data in calculations. FILTER is not used independently, but as a function that is …

Oct 24, 2025 · Find out how to focus on specific data in a Power BI report by adding a page filter, a visualization filter, or a report filter to a report.

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