Excel FILTER Function

Description The Excel FILTER function returns a range filtered on criteria you define. It can also handle multiple AND/OR criteria.

Syntax FILTER(array, include, [if_empty])

array  is the range or array containing the values you want to be filtered.

include  is the logical test that returns a Boolean array (TRUE/FALSE) of the same height or width as the array.

if_empty  is an optional value to return if the included array is empty i.e. if the filter results in no records.

Examples: