Forum Discussion
BrianGGG
Jan 30, 2019Copper Contributor
Dynamic Array formula not backward compatible
Hello. I have the Excel Insider edition and have used the new Dynamic Array formulas as follows: =SORT(FILTER(CHOOSE({1,2,3},t_Main[Rank],t_Main[Field 2],t_Main[Total]),t_Main[Rank]<(J3+1)),1) ...
- Feb 10, 2019
Unless I am getting myself confused, it is backward compatibility that is enabled by the SINGLE that inserts implicit intersection into the process, as was always the case for the traditional Excel calculation. Forward compatibility in which old versions are expected to emulate dynamic arrays will be more of an issue.
Mind you, I seem to be the only person on the planet who consistently used named formulae to bypass the Excel's implicit intersection trick and allow me to perform many array calculations without CSE. They work equally well as traditional or new dynamic arrays.
Prologys
Dec 27, 2019Copper Contributor
I have the same issue and just did a test by opening a file like that in the 365 online version and that works fine.
Just explain the people you send this to to open it with the online version.
Kind regards,
Jaap
Just explain the people you send this to to open it with the online version.
Kind regards,
Jaap