Aug 05 2024 10:54 AM
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?
Aug 05 2024 11:51 AM
SolutionThe Excel features flyer:
This link goes to a workbook that can be saved offline:
Aug 05 2024 11:55 AM
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.
Aug 05 2024 12:03 PM
Aug 05 2024 12:06 PM
Aug 05 2024 11:51 AM
SolutionThe Excel features flyer:
This link goes to a workbook that can be saved offline: