Or, to put it another way, FILTER removes rows that are zero.

This means that the two tests are mutually exclusive both tests can’t return TRUE at the same time.

In that case, the final array may contain numbers larger than 1 (i.e.

Excel formula: Filter text contains

TRUE + TRUE = 2).This makes a difference in some formulas.

The output from FILTER is dynamic.

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

Excel formula: XLOOKUP with Boolean OR logic

Excel formula: FILTER with complex multiple criteria

Excel FILTER function

Article image