Articles with the tag:
Close
Changelog
Close
Articles with the tag:
Close
Try in the cloud

FILTER Function

The FILTER function is one of the lookup and reference functions. It is used to filter a range of data and to return the results that match the criteria you specify. The FILTER function only extracts the necessary data and the results update when the original data change.

Syntax

FILTER(array, include, [if_empty])

The FILTER function has the following arguments:

Argument Description
array The range of cells to filter.
include The filtering criteria supplied as a Boolean array (TRUE/FALSE) the same height (columns) and width (rows) as the array.
if_empty The value to return when the filter returns no results. This argument is optional.

Notes

Please note that this is an array formula. To learn more, please read the Insert array formulas article.

How to apply the FILTER function.

Examples

The figure below displays the result returned by the FILTER function.

FILTER Function

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action