FILTER
Filters a range of data based on criteria you define.
| Category | DynamicArray |
| Syntax | FILTER(array, include, [if_empty]) |
Parameters
| Parameter | Required | Description |
|---|---|---|
array | Required | The range or array to filter. |
include | Required | A boolean array of the same height (or width) as array indicating which rows (or columns) to include. |
if_empty | Optional | The value to return if no items are returned. |
Example
FILTER(array, include, if_empty)
Auto-generated from the EngCanvas function registry.