Learn How to Use Microsoft Excel FILTER Function

Microsoft Excel FILTER Function

The prime usage of the Microsoft Excel FILTER function is to extract matching records, filtering the data range according to the particular criteria. It means you can utilize the FILTER function to filter a wide range of data on a given criterion.

Return Value of FILTER Function

The return value will be an array of filtered values.

Syntax of FILTER Function

=FILTER(array, include, [if-empty])

Where the arguments:

array: Range or array which you like to filter.

include: It is the Boolean array, provided as criteria.

if-empty: This is the value to return when no results are returned (optional).

How to Use Microsoft Excel FILTER Function?

As we know, the FILTER function is used to "filter" the range of data as per the supplied criteria. That will result in an array of matching values to the original range. In case the array is the final result, that means when the result is not handed off to another function, that matching result will spill on the worksheet.

In simple words, the FILTER function allows you to extract the matching records from the huge set of the source data according to the criteria provided. The FILTER function provides the dynamic result. If the source data's value is changed or the source data array is resized, the results from the filter function get updated automatically.

You can use the FILTER function in both the horizontal and vertical arrays. The "include" argument in the FILTER function must have the dimension compatible with the array function; otherwise, it will return the #VALUE!. In case the "include" array includes any error, the FILTER function will return an error.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel