Shift Rows Obstructing Spill

Brass Contributor

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

@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.

@rosenbloomsnka 

To my knowledge - no. That's usual formulas like INDEX() which return values one by one.

Mes fichiers excele ne s'ouvrent plus j'ai une message extension non valide ou fichier corrompu