Dynamic array

Above: Using theFILTER functionto return multiple matches on “red”.

In fall 2018, Microsoft announced a new feature in Excel called “dynamic array formulas”.

This behavior is called “spilling” and results appear in a “spill range”.

All results are dynamic if source content changes, the results dynamically update to stay in sync.

For details and examples, see:Dynamic Array Formulas in Excel