Forum Discussion
Shift Rows Obstructing Spill
I'm getting a "spill error" when I try to reference a table from another worksheet because there's text in a cell that is in the way. I understand that. My question is whether there's a way to have t...
rosenbloomsnka Don't think so! A dynamic array formula need space to spill its results into. As far as I know it can not automatically move occupied cells out of its way. You need to plan your work so that nothing is blocking the formula to output the results.