Introduction

The dynamic array is used to replace array formula. Any formula that has the potential to return multiple results can be referred to as a dynamic array formula. Formulas that are currently returning multiple results, and are successfully spilling, can be referred to as spilled array formulas.

In the following example, the value from C3 spills over to the adjacent cells. The value in C9 however will display the #SPILL! error as there is an existing value in the range preventing the spill.