I always try to learn from Microsoft Templates. I came across this Photo calendar template were the author was able to make cells write over legacy spilled arrays with no errors.
Does anyone know how to duplicate this? I thought we are unable to write in cells that occupy an array formula.
If on Excel with dynamic arrays you enter formula without CSE it returns spill
However, if you enter same formula with CSE it returns only first element of the array, that how dynamic array formula works
You may try on any other formula
