Dec 09 2020 09:12 AM
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 the row of that obstructing cell automatically shift down, to allow all of the data from the table to come in.
Thanks,
Scott
Dec 09 2020 09:26 AM
@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.
Dec 09 2020 09:27 AM
To my knowledge - no. That's usual formulas like INDEX() which return values one by one.
Dec 09 2020 09:32 AM