What Happens if A Formula can't spill?
August 11, 2022 - by Bill Jelen
What if we put some stuff in the way and enter one of the Dynamic Array formulas, what will happen? You will get a #SPILL! error. This is Excel's way of saying that it can't return all the results, so it won't return any of the results. The little drop-down to the left of the cell gives you the choice Select Obstructing Cells, so perhaps you can cut them and paste them elsewhere.
As soon as you clear out the obstructing cells, the results appear.
This article is an excerpt from Power Excel With MrExcel
