SOLVED

Checking availability of functionality of LAMBDA etc. between editions/versions

Brass Contributor

After seeing desirable additions to functionality in LAMBDA under Windows, for example using BYROW(array, OR) instead of BYROW(array, LAMBDA(row_, OR(row_)), I switched to the insider's edition on Mac. But when answering posts, I would like check what is available in the current versions and include a caveat note if necessary. 

 

Where can I find such subtle changes in functionality documented?

4 Replies
best response confirmed by nkal24 (Brass Contributor)
Solution

@nkal24 

The Excel features flyer:

 

This link goes to a workbook that can be saved offline:

 

https://aka.ms/xlExcelFeaturesFlyer

@nkal24 

I don't think eta reduced lambdas are separately documented, option is only mentioned in beta functions like PIVOTBY documentation. However, such beta only functions are not included in list of functions Excel functions (alphabetical) - Microsoft Support - till they are not in production.

Thank you very much. I'm very excited about the changes, I wish an easy compatibility check is available to warn about using in 'regular' editions.
1 best response

Accepted Solutions
best response confirmed by nkal24 (Brass Contributor)
Solution

@nkal24 

The Excel features flyer:

 

This link goes to a workbook that can be saved offline:

 

https://aka.ms/xlExcelFeaturesFlyer

View solution in original post