FILTER
Description
Returns a filtered range of data based on criteria that you specify.
Syntax
FILTER(
array
,
include
, [
if_empty
])
- array: The value or expression to evaluate.
- include: A Boolean array with the same height or width asarray, that identifies the data to return.
- if_empty: The value to return if the expression results in an empty array. The result must be both empty and an array; otherwise, the function returns the #VALUE error.