May 07 2020 03:19 PM
I have two computers. My personal is an insider build 2006. If I am in a cell and type =A1#, if cell A1 has a dynamic array (Unique() for example) then my formula spills and returns the full array.
However, My work computer is on 1910 (I cannot upgrade past this - corp policy right now) which also has dynamic array functions, but typing =A1# returns a #REF! error if I am pointing to an a spilled array, in this case generated by UNIQUE() as well.
Is there some crazy option somewhere on this? I thought this was all rolled out simultaneously, not # references a few months later.
May 08 2020 01:01 AM
Yes, I could be wrong but as I remember # was from very beginning, that's @ appeared some later instead of SINGLE. Strange.