Forum Discussion
LAMBDA formula not available
I' am a 365 subscriber. Windows 10 user all up to date. I deleted my current install of office and reinstalled a 64 bit ver with the correct ver of office 16.0.13426.203308. yet LAMBDA doesn't show u...
When will these new functions be available on the non-Insider builds? It's been about a year since it was announced to great fanfare.
I spoke and live chatted to MS technical support twice in the last week. The timeline for general public release is unknown.
- IMHO, only choice for users (VBA restricted by company policy) is labour-intensive naming formulas intuitive to other users; challenges i/c long names truncated by monitor width; Unicode required to emulate Excel function style.
Knowing release date of new function help cut elaboration on names. My Example: SUBSTITUTE﹙txt﹐﹛old﹜﹐﹛new﹜﹚ same as Substtitute function but array inputs; I would just choose less intuttive name.
I wish Microsoft provides VBA to emulate beta functions for earlier adoption; reluctance to change when something obsolete still works esp. when sunk cost is not small.- I also wish for Name Manager to accept Unicodes so that I can follow Excel syntax
https://techcommunity.microsoft.com/t5/excel/name-manager-accomodate-uncodes-to-follow-excel-syntax/m-p/2867714#M11881
