Returns an array of filtered rows from the specified range.
Syntax
 Copy Code
|
|---|
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.