LAMBDA and LET for a Robust Single Cell Report - Advanced Excel

The LAMBDA and LET Functions are robust functions and were recently introduced to Excel. They are only available in Microsoft 365.
When combined together, they become a game changer in Excel.
In This tutorial I combine 10 functions together in a LET then In a Lambda Function to create a Custom function that returns a beautiful Dynamic Single Cell Report and reduces the original function of 327 Character down to only 5 characters.
We have a lot to learn
So, let's dive in
You can download the Exercise File and Follow along, by clicking on the link :
www.OfficeInstructor.com/public/
You can Master Excel by learning clever techniques that combine Data validation with almost every tool in Excel. My new Book :
*************** Data Validation a back door to Master Excel ********************* *************************** is Now Available at ****************************
************************ www.Amazon.com *******************************
************************ www.Amazon.com ******************************* My New Book Is Now available on Amazon. It is much more than the Data Validation you know! Through Data Validation I Cover over 60 different Functions, Charts, Slicers, Pivot Tables, Conditional Formatting, Macros, Power Query, Dynamic Arrays, DAX, Data Model and VBA.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Booking a Corporate Training (at Client Site or Remotely)
*********************** Book A Corporate Training ************************ ***************************** With Nabil Mourad ************************
************************ www.OfficeInstructor.com **********************
************************ www.OfficeInstructor.com *********************** ##################################################### ****************************************************************************

[@marknugent5406]

Easily the most useful demonstration of the LET and LAMBDA functions in combination with the usual everyday functions most of us use. Very well presented Nabil, I was able to follow the flow and logic of the LET function.
Thank you for posting this tutorial.

[@khonesavanhsoudaloth]

Great demonstration, I love your ways to present. Your great work benefits for all . Thank for your utmost generosity

[@cpro671]

Great tutorial Nabil. As usual your teaching style of walking through each step, along with the context for each step, shows the user not just how to do it, but why you do it.

[@Officeinstructor]

You're very welcome!

[@jimfitch]

Great demonstration, Nabil. I’m a huge fan of LET & look forward to LAMBDA going to GA. *** You have a lot going on in the LET MyClass variable. I probably would break that into smaller pieces to make it easier to follow the logic. Most of my workbooks tend to have long lives (build, deploy, use with Power Query or VBA to refresh data from source(s), & return to underlying logic when something breaks or operational need changes - often weeks or months after deployment). When I return much later, I usually have forgotten the logic. The more granular the LET variable calculation & more descriptive the LET variable name, the easier I find it is to spin up my understanding of the logic. *** Thanks for the clear explanation of an excellent demonstration. From 327 to 5. Amazing, isn’t it?

[@Officeinstructor]

Glad you liked the video my friend

[@paulw8579]

The logical flow of what functions to use and when to use them is quite excellent, Nabil. It sure does seem like programming.☺️
I just kept getting confused at the SortOrder syntax: where -1 is for descending order and 1 is for ascending order.
Might need to go over it again.
Howbeit Nabil, great job once more!!

[@Officeinstructor]

Just watch this part again, I understand it is a bit confusing

[@paulw8579]

Thanks for the reply, Nabil.
Season's greetings to you.🎊☺️

[@sankaraniyer2167]

Good application and great work. Genius Nabil

[@Officeinstructor]

Many thanks

[@kebincui]

Awesome 👍

[@Saad.PS2009]

عمل جميل جدا جدا
وفقك الله ورعاك يا استاذي الفاضل

[@Officeinstructor]

Thank you my friend

[@venugopal7161]

Happy New year to all support staff of Office instructor and Nabil sir too/

[@patrickschardt7724]

Oh wow this is fantastic. The only change I would make is also adding the table name in $B$4 as another variable/parameter in the LAMBDA function. That way if there’s another similar table elsewhere in the workbook, the user can use the newly created function anywhere

[@Officeinstructor]

I agree Patrick, that would be nice. If you edit the formula and include this variable please share it with us.

[@patrickschardt7724]

@@Officeinstructor I’m experimenting with LAMBDA so if I have some time I’ll try adding it in

[@mtotowamungu8259]

Thanks a lot!
After watching this video my brain got knotted...

[@Officeinstructor]

Happy to help

[@lakhandahiya3003]

Fantastic class sir

[@Officeinstructor]

Thanks and welcome

[@ellukayou]

amazing amazing formula

[@Officeinstructor]

Glad you liked it

[@shahnazakhtar3489]

I’m a little confused how did the table change as you selected different options from the drop down box, what I mean is how is the drop down box linked to the table you created

[@sasavienne]

Here is a big *LIKE* brfore watching.

[@Officeinstructor]

You're the best!

[@kishorpanara4191]

Pls sir practice file in distribution

[@Officeinstructor]

it is in the description

[@OzduSoleilDATA]

WOW! This is terrifying. I don't know what to make of the Lambdas. 😫😭

[@Officeinstructor]

Thank you for watching my friend!!
Excel is growing exponentially overnight.

[@solimanalali8048]

plz,,, I need office 365 free

[@Officeinstructor]

You can create a trial account on Office365

[@solimanalali8048]

@@Officeinstructor sorry , but i don't know