Chapter 95

The LET and LAMBDA functions and the LAMBDA helper functions

Questions answered in this chapter:

  • How does the LET function work?

  • How can I use the LAMBDA function to create custom functions without VBA?

  • What is a recursive LAMBDA function?

  • What do LAMBDA helper functions accomplish?

  • How does the BYROW helper function work?

  • How does the BYCOL helper function work?

  • How does the MAP helper function work?

  • How does the REDUCE helper function work?

  • How does the SCAN helper function work?

  • How does the MAKEARRAY helper function work?

  • How does the ISOMITTED helper function work?

In 2020, Microsoft released the LET function to a subset of Office 365 subscribers. During the first seven months of 2021, Microsoft released to a subset of Office ...

Get Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition 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