Forum Discussion
Why doesn't the spilled range operator work?
Dynamic arrays seem to have been working on all our office PCs for a couple of weeks and formulas are spilling as expected, but if we try to use the spilled range operator in a reference (like $A2#) ...
No, I get a #REF error.
But Dynamic Arrays are working because they spill if I do something like =$A2:$A11
This is what I am trying to achieve, and how I interpreted the doco. What did you end up doing?