LAMBDA Function

Description

Build an expression (new lambda function) based on input parameters.

NOTE

• Allow recursive lambda.
• Lambda names and parameters follow the Excel syntax rules for names, without period (.) in a parameter name.
• The parameter can be a reference, an array, a lambda expression..
• The parameters can be optional by using the ISOMITTED function.

Syntax

Copied!=LAMBDA(parameter1, [parameter2], ..., calculation)
=LAMBDA(parameter1, [parameter2], ..., calculation)

EXAMPLE 1

Copied!//𝘳𝘦𝘵𝘶𝘳𝘯𝘴 𝘵𝘩𝘦 𝘸𝘰𝘳𝘥 𝘤𝘰𝘶𝘯𝘵 𝘪𝘯 𝘢 𝘵𝘦𝘹𝘵 𝘴𝘵𝘳𝘪𝘯𝘨 𝘧𝘳𝘰𝘮 𝘈1:
//𝘈1 = "𝘔𝘪𝘤𝘳𝘰𝘴𝘰𝘧𝘵 365"

=LAMBDA(text, COUNTA(TEXTSPLIT(TRIM(text), " ")))(A1) -> 𝘳𝘦𝘵𝘶𝘳𝘯 2
//𝘳𝘦𝘵𝘶𝘳𝘯𝘴 𝘵𝘩𝘦 𝘸𝘰𝘳𝘥 𝘤𝘰𝘶𝘯𝘵 𝘪𝘯 𝘢 𝘵𝘦𝘹𝘵 𝘴𝘵𝘳𝘪𝘯𝘨 𝘧𝘳𝘰𝘮 𝘈1:
//𝘈1 = "𝘔𝘪𝘤𝘳𝘰𝘴𝘰𝘧𝘵 365"

=LAMBDA(text, COUNTA(TEXTSPLIT(TRIM(text), " ")))(A1) -> 𝘳𝘦𝘵𝘶𝘳𝘯 2

EXAMPLE 2

Copied!//𝘳𝘦𝘵𝘶𝘳𝘯𝘴 𝘵𝘩𝘦 𝘶𝘱𝘱𝘦𝘳 𝘵𝘳𝘪𝘢𝘯𝘨𝘶𝘭𝘢𝘳 𝘮𝘢𝘵𝘳𝘪𝘹 𝘧𝘳𝘰𝘮 𝘈1:𝘊10:
=LAMBDA(a, --(SEQUENCE(ROWS(a))<=SEQUENCE(, COLUMNS(a))))(A1:C10)
//𝘳𝘦𝘵𝘶𝘳𝘯𝘴 𝘵𝘩𝘦 𝘶𝘱𝘱𝘦𝘳 𝘵𝘳𝘪𝘢𝘯𝘨𝘶𝘭𝘢𝘳 𝘮𝘢𝘵𝘳𝘪𝘹 𝘧𝘳𝘰𝘮 𝘈1:𝘊10:
=LAMBDA(a, --(SEQUENCE(ROWS(a))<=SEQUENCE(, COLUMNS(a))))(A1:C10)

EXAMPLE 3

Copied!//𝘳𝘦𝘱𝘦𝘢𝘵 𝘦𝘢𝘤𝘩 𝘤𝘩𝘢𝘳𝘢𝘤𝘵𝘦𝘳 𝘰𝘧 𝘵𝘩𝘦 𝘴𝘵𝘳𝘪𝘯𝘨 𝘪𝘯 𝘈1 𝘯 𝘵𝘪𝘮𝘦𝘴:
//𝘈1 = "𝘢𝘣𝘤"

=LAMBDA(a, n, CONCAT(REPT(MID(a, SEQUENCE(LEN(a)), 1), n)))(A1, 5) -> 𝘳𝘦𝘵𝘶𝘳𝘯 "𝘢𝘢𝘢𝘢𝘢𝘣𝘣𝘣𝘣𝘣𝘤𝘤𝘤𝘤𝘤"
//𝘳𝘦𝘱𝘦𝘢𝘵 𝘦𝘢𝘤𝘩 𝘤𝘩𝘢𝘳𝘢𝘤𝘵𝘦𝘳 𝘰𝘧 𝘵𝘩𝘦 𝘴𝘵𝘳𝘪𝘯𝘨 𝘪𝘯 𝘈1 𝘯 𝘵𝘪𝘮𝘦𝘴:
//𝘈1 = "𝘢𝘣𝘤"

=LAMBDA(a, n, CONCAT(REPT(MID(a, SEQUENCE(LEN(a)), 1), n)))(A1, 5) -> 𝘳𝘦𝘵𝘶𝘳𝘯 "𝘢𝘢𝘢𝘢𝘢𝘣𝘣𝘣𝘣𝘣𝘤𝘤𝘤𝘤𝘤"

RELATED