© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022
A. MurrayAdvanced Excel Formulashttps://doi.org/10.1007/978-1-4842-7125-4_15

15. LET, LAMBDA, and the Helper Functions

Alan Murray1  
(1)
IPSWICH, UK
 

Formulas in Excel have seen numerous fantastic advances in recent years including the introduction of dynamic array formulas and many brilliant new functions such as TEXTJOIN, XLOOKUP, and STOCKHISTORY. The development of LAMBDA functions in Excel was another tremendous leap in the advancement of formulas in Excel.

With LAMBDA, you can create your own functions in Excel. So, if Excel does not have it, you can create it. This is very special. What an awesome functionality to be introduced. It is also a lot of fun. ...

Get Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial