That aint a new aJAX based web service or a community site for head_scratchers_with_left_hand_middle_fingerers or something. Be warned.
My computer, Madhu as I call it got a major upgrade two days ago. The 6 year old marathon win2k, p3, 256mb, cd rw system is now a spanking new p4 3ghz, 512 mb ddr, 160 gb sata and dvd rw system with windows xp. I was really depressed to see the old with all the capacitor junk and infuriatingly long start-up delays. I think this config should keep me current for atleast 2007.
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...