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
[ Ссылка ]
My GIST:
[ Ссылка ]
Joint GITHUB to create your own GIST
[ Ссылка ]
Connect with me
[ Ссылка ]
Ещё видео!