FILTER

Returns an array of filtered rows from the specified range.

Syntax

FILTER( ReferenceOrArray range, ReferenceOrArray include, [Any ifEmpty] ) → Array

Parameters

range

Required. The range or array to filter.

include

Required. A range or array of boolean values specifying which rows to include.

ifEmpty

Optional. A value to return if the result array is empty.

Remarks

The result array includes rows from the source range whose matching values in include array evaluate to TRUE.

Results spill into cells adjacent to the one that calls FILTER. If they are occupied, the formula returns #SPILL error.

See Also

Function Reference
SORT Function
UNIQUE Function