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/t5/excel-blog/announcing-lambdas-to-production-and-advanced-formula/ba-p/3073293 My GIST: https://gist.github.com/wynhopkins/02e4d1951e65334db53ce17f5519190f Joint GITHUB to create your own GIST https://github.com/join Connect with me https://wyn.bio.link/