All three arrays are multiplied together.

The output from FILTER is dynamic.

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

Excel formula: Filter text contains

For example, =LEFT(“apple”,3) returns “app”.

When given TRUE, NOT returns FALSE.

When given FALSE, NOT returns TRUE.

Excel formula: Filter this or that

Use the NOT function to reverse a logical value.

Excel formula: FILTER with multiple OR criteria

Excel FILTER function

Excel LEFT function

Excel MONTH function

Excel NOT function