Excel: 2021, 365, for Mac and web
Excel appeared in 1987, and only after 34 years create the formula FILTER ????? Impossible!
Example of use
The Excel FILTER function filters a range of data based on supplied criteria and extracts matching records.
Syntax
=FILTER (array, include, [if_empty])
- array – Range or array to filter.
- include – Boolean array, supplied as criteria.
- if_empty – [optional] Value to return when no results are returned.