CSE Array Formula

[schielrn]

I didn't know where else to post this and I haven't found anything online to say this is true or when it was released.

It appears you no longer have to use Control+Shift+Enter to confirm an array formula and just pressing enter will work and not return #VALUE anymore?

Can anyone else confirm this or provide an article that says this is true now?

Thanks!

 

[Fluff]

Entirely depends on your version & build of Excel.
If you have a dynamic aware version then (in the main) you no longer need CSE.
Only 365 is dynamic aware, but it depends on what build/version you have. If you have functions such as SORT & FILTER, then it's dynamic aware.

 

[schielrn]

Thank you! I do have Version 2009 and do have SORT and FILTER. I am hoping I can come across an article about this, but I am going to guess not.

 

[Fluff]

Not quite sure why you need an article, but there was a lot of stuff about it on the net, when it first surfaced.

 

[schielrn]

I actually found this from back in 2018. I was just curious when it was from and when approximately it was released was all.

Excel: Microsoft unveils Dynamic upgrades

In the first instalment of a seven-part series, Excel MVP Liam Bastick introduces the first major leap forward to spill from Microsoft’s partial rewrite of its spreadsheet application’s “calculation engine”.

www.fm-magazine.com

Thanks for the information.

 

[Fluff]

Not sure when they first appeared on the insider channels, but MS started to release the new functions to subscribers on the monthly channel in Nov last year & to people on the semi-annual channel in July this year.

 

[Peter_SSs]

I was just curious when.... it was released was all.

As far as I am aware, still not everybody with 365 has the dynamic array functions.