FILTER Function Explained
The FILTER function in Microsoft Excel allows users to filter a range of data based on criteria provided. It returns a subset of the original range that meets the criteria specified. It can be used to extract specific rows or columns from a larger dataset. The syntax for the FILTER function is FILTER(array, include, [if_empty]), where array is the range of cells to filter, include is the criteria used to filter the range, and if_empty is an optional argument that specifies what to return if the filter returns no results.
FILTER Function Syntax
FILTER(array, include, [if_empty])
- array: The range of cells to apply the filter to.
- include: The range of cells containing the criteria to filter by.
- if_empty: (optional) The value to return if the filter returns no values. If omitted, an empty array is returned.