Exciting New Excel LET Function - Comprehensive Guide - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
10ozGold
Great video Mynda. I learned a lot. Thank-you! At the 15:17 mark, Adventure Works is ranked #3 with Sales of 16. However, The Phone Company also has Sales of 16...tied for 3rd place. When I changed the RankArray to -1,2,3,4-, the spill repeats Adventure Works in both 3rd and 4th place as INDEX will obtain only the first instance. 1) How would you modify the formula to solve for ties? 2) The LET formula spilled across for me. I had to use TRANSPOSE to wrap INDEX to spill down. How did you get the formula to spilled down without TRANSPOSE? Thank-you :)
reply
Great video Mynda. I learned a lot. Thank-you! At the 15:17 mark, Adventure Works is ranked #3 with Sales of 16. However, The Phone Company also has Sales of 16...tied for 3rd place. When I changed the RankArray to -1,2,3,4-, the spill repeats Adventure Works in both 3rd and 4th place as INDEX will obtain only the first instance. 1) How would you modify the formula to solve for ties? 2) The LET formula spilled across for me. I had to use TRANSPOSE to wrap INDEX to spill down. How did you get the formula to spilled down without TRANSPOSE? Thank-you :)
reply
Bill
Just a hint: The microphone in the opening and closing of the tutorial is used wrong. That's why the sound is echo-y in those sections. The diaphragms in that bi-directional microphone face sideways, behind the angled sections of the screen. So she is talking sideways into the microphone--90 degrees to the diaphragms, and they are picking up lots of reflected echoes from the rest of the room. A different mic (or different placement) was used for the body of the tutorial.
reply
Just a hint: The microphone in the opening and closing of the tutorial is used wrong. That's why the sound is echo-y in those sections. The diaphragms in that bi-directional microphone face sideways, behind the angled sections of the screen. So she is talking sideways into the microphone--90 degrees to the diaphragms, and they are picking up lots of reflected echoes from the rest of the room. A different mic (or different placement) was used for the body of the tutorial.
reply
Meni
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.
reply
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.
reply
Deependra
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.
reply
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.
reply
Life
Great function, I built a complicated spreadsheet using and made my life so much easier...then DISASTER, I distributed to other users and everything broke. Then I discovered it was a beta function...who does that! Why release a beta function in a live environment without warning the programmers!
reply
Great function, I built a complicated spreadsheet using and made my life so much easier...then DISASTER, I distributed to other users and everything broke. Then I discovered it was a beta function...who does that! Why release a beta function in a live environment without warning the programmers!
reply
ahoy037
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.
reply
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.
reply
CA.LOKENDER
In the attached file of this video there is sheet -prior names-. in this sheet cell F6 is changing when we click different radio buttons. But there is no formula in cell F6. would you pls tell me how it is possible? it will be helpful.
reply
In the attached file of this video there is sheet -prior names-. in this sheet cell F6 is changing when we click different radio buttons. But there is no formula in cell F6. would you pls tell me how it is possible? it will be helpful.
reply
ZX-25R
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
reply
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
reply
Ravi
Really nice Minda! Had a query, if you have used a LET Function in EXCEL 365 & you send this report by mail to someone with Microsoft 2013 or 10, will that person able to read values? read formula? or they will get ##N/A?
reply
Really nice Minda! Had a query, if you have used a LET Function in EXCEL 365 & you send this report by mail to someone with Microsoft 2013 or 10, will that person able to read values? read formula? or they will get ##N/A?
reply
Sachin
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 :)
reply
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 :)
reply
Add a review, comment
Other channel videos
