Summary
In this video we take a first look at the FILTER function.
Tab in example file: Quick Start
The FILTER function filters a range or array based on an array of TRUE/FALSE values. Returning only the corresponding values where the array equals TRUE.
The Syntax of the function is:
=FILTER(array, include, [if_empty])- array – Array or range to return values from.
- include – Array of TRUE/FALSE values. Only TRUE values returned.
- [if_empty] – Value(s) to return if no rows returned.
The filter direction is based on the orientation of the include argument:
- Vertical – Filters rows
- Horizontal – Filters columns
The array and include arguments must include the same number of rows/columns depending on the orientation.