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
techcommunity.microsoft.com/t...
My GIST:
gist.github.com/wynhopkins/02...
Joint GITHUB to create your own GIST
github.com/join
Connect with me
wyn.bio.link/
Негізгі бет Тәжірибелік нұсқаулар және стиль What is LAMBDA in Excel
Пікірлер: 74