the hash/pound # operator not working for Dynamic Arrays

%3CLINGO-SUB%20id%3D%22lingo-sub-1372163%22%20slang%3D%22en-US%22%3Ethe%20hash%2Fpound%20%23%20operator%20not%20working%20for%20Dynamic%20Arrays%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1372163%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20computers.%20My%20personal%20is%20an%20insider%20build%202006.%20If%20I%20am%20in%20a%20cell%20and%20type%20%3DA1%23%2C%20if%20cell%20A1%20has%20a%20dynamic%20array%20(Unique()%20for%20example)%20then%20my%20formula%20spills%20and%20returns%20the%20full%20array.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20My%20work%20computer%20is%20on%201910%20(I%20cannot%20upgrade%20past%20this%20-%20corp%20policy%20right%20now)%20which%20also%20has%20dynamic%20array%20functions%2C%20but%20typing%20%3DA1%23%20returns%20a%20%23REF!%20error%20if%20I%20am%20pointing%20to%20an%20a%20spilled%20array%2C%20in%20this%20case%20generated%20by%20UNIQUE()%20as%20well.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20some%20crazy%20option%20somewhere%20on%20this%3F%20I%20thought%20this%20was%20all%20rolled%20out%20simultaneously%2C%20not%20%23%20references%20a%20few%20months%20later.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1372163%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1372912%22%20slang%3D%22en-US%22%3ERe%3A%20the%20hash%2Fpound%20%23%20operator%20not%20working%20for%20Dynamic%20Arrays%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1372912%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F236847%22%20target%3D%22_blank%22%3E%40Ed%20Hansberry%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYes%2C%20I%20could%20be%20wrong%20but%20as%20I%20remember%20%23%20was%20from%20very%20beginning%2C%20that's%26nbsp%3B%40%20appeared%20some%20later%20instead%20of%20SINGLE.%20Strange.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Contributor

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. 

1 Reply
Highlighted

@Ed Hansberry 

Yes, I could be wrong but as I remember # was from very beginning, that's @ appeared some later instead of SINGLE. Strange.