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...
To my knowledge - no. That's usual formulas like INDEX() which return values one by one.