What is LAMBDA in Excel

A simple introduction explaining LAMBDA in Excel.  Also introducing the Advanced Formula Environment.   I'll demonstrate creating a function to return a filtered list based on a search word.
🔽  More Stuff to Read 🔽
Check if you already have LAMBDA by typing =LAM in a cell and LAMBDA will appear.

**Important Point** LAMBDA will not be backwards compatible and users will see ?NAME errors if they change any value that the LAMBDA function references


00:00 Intro
01:12 The End Result
01:55  Installing the Advanced Formula Environment
02:28 Creating a formula that will then be converted to a LAMBDA
05:20 Using the Advanced Formula Environment to create your LAMBDA function
10:50 Keeping a centralised repository of your LAMBDA functions in a Github GIST


Official Lambda Blog Post
https://techcommunity.microsoft.com/t...


My GIST:
https://gist.github.com/wynhopkins/02...

Joint GITHUB to create your own GIST
https://github.com/join


Connect with me
https://wyn.bio.link/