FILTER
Filters a range of data based on criteria you define
Syntax
FILTER(array, include, [if_empty])
Parameters
- array: Required. The array or range to filter
- include: Required. A Boolean array whose height or width is the same as the array
- if_empty: Optional. The value to return if all values in the include array are FALSE (empty)
Example
=FILTER(A1:D10, C1:C10="Yes")