-
– During formula typing, adjusts the reference type, abs to relative, otherwise repeats last action
-
+
– Inserts current date -
+
– Copies value from cell above to current cell -
+
– Edits a cell comment -
+
– Opens macro dialog box -
+
– Auto sum selected cells and places value in cell beneath -
++
– Currency formats current cell -
++
– Applies outline border to selected cells -
++
– Comma formats current cell -
++
– Activates font drop down list -
++
– Activates font point size drop down list
What is your favorite keyboard shortcut / productivity tip?
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...