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#) ...
As far as I know, # notation is used to refer the spilled range.
As per the screenshot in your last post, since C2:C11 is a spilled range after you placed the formula =A2:A11 in cell C2 so if you type =C2# in any cell say in cell D2 (remember not to press Enter, just type it), you will find that the range C2:C11 would be selected.
Thanks, I see now how I had misunderstood the documentation.