Nov 20 2020 02:00 AM
How to resolve Excel volatile Spill Error in office 365 i.e. indeterminate behavior
Nov 20 2020 02:32 AM
As with any other error, correct the formulas or range to which they return result, such way that they work correctly with dynamic array Excel.
Simplest way could be to add Implicit intersection operator: @ in front of formula or range/array you use.