Winners of Sales Analysis Chart Contest:
Yesterday we saw the entries for the sales analysis chart contest. Today, we will find who the winner is…,
Oh, wait!
I have decided to award the prize to 2 contestants. Each of them will get an Amazon Kindle Reading Device.
The winners are,
And there is a third prize too. This will be Excel 2010 Power Programming Book by John Walkenbach.
The winner is,
- Nadeem (Option 31)
Congratulations to the winners.
Also, all the participants of this contest will receive a small surprise bonus. Wait for it until this weekend.
PowerPivot T-shirt Giveaway
Recently, I got an email from Emilie, a member of PowerPivot (review) team at Microsoft, who promised to do backflips if I promote their PowerPivot Contest. I did promote the contest (here). But she went back on her backflips promise and instead sent me a 4 PowerPivot t-shirts. They are really cool. But, unfortunately, I cannot wear all of them.
So I am going to give away these 3 shirts (shown below).
How does this giveaway work?
- I can only send these shirts to addresses in India.
- To participate, just post a comment on this article. Anything goes.
- The shirts are in Girls L, Girls M, Guys L sizes.
- This contest closes on 3rd July, 11:30 PM IST (Indian Standard Time, we are GMT +5:30)
- What are you waiting for? Go!
That is all for now. I will see you next week with more Excel awesomeness. You have a beautiful weekend then.
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...