Excel 2024 functions doc. error?

Question

Excel 2024 functions doc. error?

Hi

Found Why there no such as LET, LAMBDA, SCAN, TEXTSPLIT formula on my excel? but the answers don't really address the question

On Excel functions (alphabetical) page:

but clicking the BYCOL hyperlink:

and that's the case for a number of other functions (didn't check them all)

Can someone having 2024 quickly fill (Y/N) column [Applies To 2024?] (23 rows) in this shared filePlease?

Thanks much
Lz.

Answer 1

Hi @Jhun Buala

(FYI I run 365. If I did run 2024 I could have checked myself and wouldn't have asked the question)

Thanks much for the quick answer. However, I'm a bit confused with the following:

If you are using Excel 2024, the one time purchase app, non-subscription type

One time purchase app = Perpetual version (correct me if I'm wrong)

Non-subscription type. It's my understanding that subscription only applies to Microsoft 365. Assuming this is correct, what do you exactly mean with Non-subscription type when talking about Excel 2024?

EDIT: On reflection... If LAMBDA is in 2024, ISOMITTED should be but you didn't mentioned the latter in your list. Could you double-check please?

Thanks
Lz.

Answer 2

Hi Lz365,

Good day. I'm Jhun an independent advisor. Regarding your issue, you are running into a documentation/version mismatch and not a bug.

If you are using Excel 2024, the one time purchase app, non-subscription type, the following functions are not included on this version.

Function Type Available in Excel 2024?

LET
LAMBDA
SCAN
BYROW
BYCOL
TEXTSPLIT
TEXTAFTER
TEXTBEFORE
MAP
REDUCE

These are part of the dynamic array and Lambda helper functions, which Microsoft keeps exclusive to Excel for Microsoft 365 subscription, and Excel for the web.

Regards,
Jhun