Thanks Mynda, for the articulate demonstration of how the LET function works, providing various scenarios. It's a strong programming concept for Excel users!

This is such a magic function! And, especially for remembering, as well as transmitting your logic to others, when you look at it at any later time. Also, absolutely clear and precise presentation. I always find your video's very high-level, utterly professional, with plenty of practical, useable examples and pure learning. Thanks, Mynda!

Last example on debugging rocks! Great way to manually evaluate your formula!

There're so less number of women on the web doing intellectual and tech work. You're one of those few. Keep it up👏👏👏👏👏!

This is absolute magic. I'm already thinking of going back to some of my excel spreadsheets and applying the LET function. Thank you so much.

Amazing! I just suggested my team subscribe due to all of your content being relevant. Thank you again!

Allowing debugging! Mind blown! Thank you for this

Clear, concise and relevant! I appreciate your style of delivery and the examples given. Just need to put some of these options in use. Thank you!

Thanks for the video! This changes so many things I've done in previous spreadsheets. Started seeing your channel today as a recommendation from KZfaq and can't be happier for it. I'm having my teams subscribe to your channel for sure, easy to understand videos and very relevant.

Thanks so much for this well explained and succinct introduction for this new function. Really liking what you're doing, keep it up Mynda!

Such a great and informative channel. Thank you. So happy for youtube to recommend it.

Great video, a thorough coverage of the LET function indeed! I've been using it for a month now and I think it's fantastic. I use the debugging approach you suggest too, it is a great way to step through your formula, especially as they get more and more complex. I've just made it a rule that I output the final step as the return of a single variable (as you did in your example) always, like the "in" step in M code. It really does throw the world of excel formulas in a whole new direction. The complexity offered in a single formula is huge, and it'll take quite a balancing act between keeping things simple over having less formulas. For example, in your Top 3 example I would have used the choose formula in the final variable to return 1, the name, 2, the XLOOKUP value, thus returning the whole table in one formula (I'd have maybe used sequence instead of {1,2,3} with a user input for the number, but I realise you were just showing a single example!). I think I'm of the opinion that if you're having to copy a formula down, like you did with the xlookup, then I would append to the single Let formula rather than have to copy further down if you wanted top 4 or whatever. If it's more pivot-like, as in your FILTER formula with the dates/months across the top and you have an unknowable number of columns, I'd do as you did. It'd be interesting to see a video touch on these concepts and best practices, as I'm struggling to define the best approach with LET.

Hi Mynda, That new formula is amazing!!!! Thank you!!!!

Neat! Great presentation, as always. Thank you so much, Mynda!

That's the easiest examples to make it understand at once. Thank you.

I am really pleased I found this channel - very well explained and presented. One of the best I have seen, well done

Thank you Mynda! Another very clear and useful presentation!

Finally got to use LET at work. Thanks for helping me understand it!

Thanks a lot for your presentation and channel. You are one of my favorites "Excel teachers"

That's great. I've wanted a LET function for years. This will probably let me avoid making many of the VB UDFs I usually resort to. And you used some other functions I wasn't aware of. Lots to digest here. Thanks! I just subscribed. :-)

I had a chemistry problem today I shirked because it would take a few hours to transpose into the right excel form and the resulting formula would look like inpenetrable garbage... this will make a huge difference without having to create a bunch of defined variables. Thanks for the clear walkthrough, and peppering it with a few neat uses of other functions to boot!

I am looking forward to using this function. It looks incredible and will make so many of my worksheets much easier to write, debug and come back to months or years after first being written.

That is a great way to make really complex formulas easier to read for others (and for me when I go back to an old file !)

Thanks for sharing, this is great feature. I wasn't aware of the new Excel features LET, CHOOSE, FILTER, XLOOUP, etc... Will definitely need to brush up my Excel knowledge as these new formulas can improve the existing ones

Thank you for this marvelous and elaborate video on Let. Each and every example is amazing. I liked that Alt+Enter trick, not many people know this. I often use this trick while writing long IF statements. Cheers :)

Simply Excel Brilliantly! I think your excel skills are the biggest contribution to Excel since its introduction Nov 1987. I wish you and your family a Merry Christmas and a very prosperous New Year

Hi Mynda, this is indeed an eye-opening lecture. One very interesting feature of the LET function is that you can use a name within a name. That is, a name may contain previously defined names in the very same LET function. For example, in your last illustration: The "Calc" name refers to ("contains") other predefined names ("Rng", "SelectedBrad", "SelectedCategory"). This feature is very useful, especially when your formula is quite complicated.

The formulas which you are telling are quite a high level one. And I find quite useful and difficult too. Thanks for sharing valuable information.☺️

Thanks a million mynda That was magical It saves times and clarifies formulas . Thanks for your help and for your time Appreciate 🤩

Apart from programming like VBA, LET also reminds me of algebra done at school. Great video, Mynda.

Excelente vídeo. Great explanation with very illustrative examples. Thank you.

Seems to be a very useful function. Eager to try when it is released. Thank you for excellent explanation.

Wonderful ! You show me something useful. You write your formula in many lines by splitting with Alt+Enter. By that, a complexe formula become simple to read. Ex. =IF( A1

Amazing Video Myndy. I have the 365 Insiders so I have been enjoying and practicing the LET Function and this will add to my practice!!! Thanks very helpful. : ) : )

Perfect function. perfectly explained. appreciated. Thank you so much, dear tutor.

This is such a magic function! indeed - this video deserves 1mio views!!!!!

Brilliant. Very easy to follow with your explanations. Thank you

What a magisterial presentation. Thank you.

That's a fantastic function. It reminds me the syntax of one more very useful function "Choose". Thanks for sharing.

Wow this is amazing and yet at same time so advanced I will have to watch more than once to understand how you can do this thanks for videos you and husband are amazing

Great function (milestone!) and great lesson! Thank you.

Being able to declare variables is a very important step of the new calculation engine. I see excel starts to look more like a traditional programming language.

Thanks a lot.. 🌟 🌟 🌟 I could learn new skills through this tutorial..

Hi Mynda. Great examples! Well explained and useful. Thanks for sharing :)) Thumbs up!!

Wow. Daz a killer video on LET Function. Well presented but requires more practice to master.

I am subscriber of leila gharani channel so understood 80% whats going on. So definitely recommend this channel to my friends and subscribed this too.

Hey, I just came across your channel and really enjoyed this video and your clear presentation. I love Excel and I can't wait to go through more of your videos! If I can offer you one piece of advice in return for your generosity - you are speaking into the top of your mic when you should be speaking into the side (which is actually the front). There is normally a 'dot' on the side of the mic to identify which is the front side as opposed to the rear. You will get a much fuller and more natural sound to your voice if you do this. Best wishes D.

Hi Mynda, It's impressive to learn such formulas in excel. Thanks for sharing such a useful information. Please do make video on VBA from beginning level.

Mind Blowing.

Thank you Mynda, as usual very very good explained. I don't have LET yet but it will come soon I hope. I liked the debugging part, comparable with the VBA window to see the values of the variables. At this moment I would prefer names in formulas in stead of LET, but I do not work with that large files with formula's. But it is good to know that that there is a LET that can maybe solve your performance issues. btw: nice notebook you have on your desk..;)

Excellent Tutorial and very useful function. Thank you

Thanks a lot for it. Simply, great!

An excellent presentation, I learnt a lot. Thanks.

I don't really know why am I seeing this, but I am glad that Excel users can finally have local variables. Maybe you will even get loops someday, idk...

Excellent video, learnt a lot in few minutes....

LET's magic. Amazing video

Now let fn is available i ofc 365 n i have practiced everything shown in video. It took 2 hrs to practice everything as i was forgetting brackets while using filter fn n was giving errors to me. But have to say its great tool to avoid writing formulas again and again n again. Now i can give variable to name and calculation as many time as possible.

Great tutorial as always!!!!

Thanks Mynda. Really very informative and i am great fan of your videos. Just to add, alternative to LET function, we can also use VLOOKUP function with a return type as 1.

Another awesome lesson, thank you

Frist, that was a great, clear presentation! In other news: we finally get a feature that's been available in BASIC since 1964. Now that's what I call progress. ;-/

Love your videos!

Hello, thank you for the detailed walk-through. Could you briefly explain the benefit of using the LET() vs using name manager and naming ranges? I believe you can achieve a similar outcome with the right combination of ifs and dynamic ranges.

nice one, i will start to use it , rather than retyping the formulas again and again or copy pasting

Like the hair cut! Cute!

👍👍👍...Thank you Mynda.

Great lesson and great new feature. Can't wait to see LET in the official release. Also thank you for reminding me about ISERROR. Esp with xlookup/vlookup (as you mention) I have so much redundant code! ISERROR helps a lot.

Hi Mynda, Very interesting video about this function. Simply amazing!! Request you to please make VBA tutorial.. It will be very helpful. Thanks

I've always wanted something like this in Excel in order to reduce the number of times I have to repeat the same formula within a formula. I've always ended up having to use helper cells to make the formula readable. I hope they release to the public soon.

excellent session

Just tired this and it worked, not sure when I got the update as not insider, all I know is when I first tried it, I didn't have it. Great intro, looked at some others and they went into using it in quite complex ways which is not great when you just need to understand the syntax, this goes for DAX, M or Excel. Have you ever considered a video on Microsoft 'insider' as I've thought about it but always been wary.

This is great, especially for the readability. Although SUM() is used multiple times in the formula, Excel's formula execution may be smart enough to optimize and only perform SUM() once. I would hope it does this.

Absolutely excellent video! Great new formula plus I learned some useful stuff about other things, I've been manually converting table references to absolute for months. Never occurred to me copying and pasting as opposed to dragging was all I needed to do!!! One query, in the relative references section, you used G3 in both the start and end of month variables. Would I be right in thinking you could have used your already declared start of month variable in your EOMONTH formula instead of G3? Liked and subscribed by the way :-)

And thanks very much for thus great video

Excellent video! This got me stoke, 'cause I come from the programmer level, and every time I try to get into excel I always get lost in these one-liners and repetitive commands... therefore I now joined the insiders'. For anyone that's trying to get it, Microsoft has a page for MDT config xml but they had removed the Insiders channel from it and even if you add it in the config file won't work(at least from my experience)... instead need to create a key in the registry over what you already have installed, and then hit update one more time (as won't get any sign that you are an insider)... -that was fun! cheers!

Omg, LET with the development of XLookup are game changers. Haha, over the past couple decades I've written some ridiculous and convoluted conditionals. LET is so much more efficient!!!

Excellent!

very useful!

Thank you

Wtfffff... finally some increible useful for better performance and power ups

that is pretty useful. Anything too large I just do it in VBA. So much more powerful and flexible.

👏🏻👏🏻👏🏻 this was great

Thanks a ton

Thanks you :)

Thats really great! Thats incredible useful :D unfortunatelly we dont use m365 in the company :(

Amazing!!

I created functions to find the numerator and denominator of a value with a fraction C2 contains the value C3 contains a string with a number of questionsmarks Numerator: =LET( form;C3; part;TRIM(TEXT(MOD(C2;1);form&"/"&form)); VALUE(LEFT(part;FIND("/";part)-1)) ) Denominator: =LET( form;C3; part;TRIM(TEXT(MOD(C2;1);form&"/"&form)); VALUE(MID(part;FIND("/";part)+1;LEN(form))) ) With these combined you cab create a different fraction format with more then 3 digits

Thank you! Also your so beautiful!

Simply awesome

You are always making amazing videos ✌️👌😁. But, I am currently struggling with Google sheet online in which I am trying to create a protection in the enter sheet only those cells and columns that has a specific word, so in a nutshell, I want to make automatic protection based on conditional. For instance, I have a data entry in which the team leaders fill it and I have a column to approve them, if I said yes then automatically lock these cells for them, and if it was no then leave it as it is. Thanks in advance. I have searched a lot but didn't find anything like this.

Great video, i hope i can use this function asap. Btw, i can use xlookup function but can't use # in my references.I don't know what's going on 😔

Amazing 😍

Thank you for a great video! I just subscribed to your channel! :) I noticed on the array input and output segment there were two vendors that tied for third but it chose the one one that was listed first alphabetically. Adventure Works had 16 but so did The Phone Company. Is that because of the way the table was sorted or is that because of how Microsoft programmed the function?

Mynda, you explained it so easy to remember. thanks you so much. i am glad i just found such a good teacher. keep it up!

Now i am not programmer and not familiar with advance array formulas but will definitely grab it after practicing it. 3 examples in one video made it lengthy. Suggest you to make just one or 2 examples of 10-12 mnt max. Otherwise great video. So will wait for office 365 monthly roll out because i have that plan.

Great video!!! I have a question, when i divide two number on excel (ex. =5/10), excel immediately change the value of cell by 0.5. And if I need to know the data that I introduce (5 and 10), it doesn't appear.... How I can set up that excel remain the formula (=5/10) on that cell...?

Super awesome

Thank you very much for the video you made. It is very educative and I appreciate it! Question: In what position should I use the "UNIQUE" function to make sure that the product does not repeatedly appear in the result? Thank you!

Wow it’s really a good function and video too!!! BTW I’m already an insider of 365, but I still can’t see this function yet? Do u have any idea? Thanks!

Why are people downvoting this? Wow.