Almost an year ago, my life took a pleasant, awesome turn. I became dad to two beautiful, naughty and energetic kids. We named them Nishanth & Nakshatra (meaning Moon & Star). Ever since they entered our world, our lives have changed. They bring laughter, love, anxiety and curiosity to our life everyday. And this Friday (24th Sept), they will be one year old.
To mark the occasion, we are having a mild extravaganza at our home in Vizag, India (here). I would be very happy if you can join us and bless our babies on this occasion.
If you are planning to come, just drop me an email at chandoo.d @ gmail.com and I will email you address and details.
Thank you.
8 Responses to “What is LAMBDA? 4 Practical examples to REALLY understand it”
Thanks so much for this, it's utterly brilliant!
Silly question - I assume LAMDA will work with dynamic arrays?
Very much so. Many of the new functions like MAP only make sense in the context of dynamic arrays and Lambda functions.
As usual, very informative material. Easy to understand and apply!
Thanks for making everyone awesome!
Easy to understand Lambda function through this tutorial. Thanks Chandoo.
I have Officce 365 (updated), but I can't see LAMBDA function. 🙁
I dont see "Office Insider" option in my excel 365.
Another option for First Monday...
=LAMBDA(anydate,WORKDAY.INTL(EOMONTH(anydate,-1),1,"0111111"))
Loving the binary options in WORKDAY.INTL David...