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 the row of that obstructing cell automatically shift down, to allow all of the data from the table to come in.
Thanks,
Scott
3 Replies
- Mes fichiers excele ne s'ouvrent plus j'ai une message extension non valide ou fichier corrompu
To my knowledge - no. That's usual formulas like INDEX() which return values one by one.
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.
