LAMBDA: I built my own Excel function without touching VBA, and now I use it daily

I kept rebuilding the same formula until Excel let me name it
LAMBDA turns a formula you lean on into a function you can call by name
I built my custom function inside the Name Manager
The whole thing took one dialog box and zero lines of code
The functions I actually reach for every day
Two that earned a permanent spot in my workbooks
LAMBDA isn’t always the right call
When a plain formula or an actual macro still wins
Where I’m taking my homemade functions next
Custom functions get more useful the more you stack them

LAMBDA: The ultimate Excel worksheet function – Microsoft Research

LAMBDA: The ultimate Excel worksheet function