How to include a name to a lambda function in Excel 365 on OneDrive

Occasional Visitor

How to include a name to a lambda function in Excel 365 on OneDrive

1 Reply

@LHCeroni There's no Name Manager in the on-line version so you will have to use the "Advanced Formula Environment" on the Formulas ribbon.

Riny_van_Eekelen_0-1669204985894.png

Click the icon, then on the Names tab and the big + sign. Fill in the Function name, the description (optional), add arguments to be used in the LAMBA and then the function itself in the definition box. Press Done.

Riny_van_Eekelen_2-1669205694203.png