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/
