Thearrayargument is provided as the named rangedata, which contains the full set of data without headers.

Theincludeargument is constructed with the MONTH function:

Here, MONTH receives the range C5:C15.

Only rows where the result is TRUE make it into the final output.

Excel formula: Filter text contains

Theif_emptyargument is set to “No data” in case no matching data is found.

The output from FILTER is dynamic.

If source data or criteria change, FILTER will return a new set of results.

Excel formula: Filter data between dates

Excel formula: Filter with multiple criteria

Excel formula: FILTER with complex multiple criteria

Excel FILTER function

Excel MONTH function