You're here for Excel. I'm here for Chandoo jokes.
@AnthonyEnglish
3 ай бұрын
I’m only 8 minutes into this video and can’t believe how much you’re able to pack into it. That formula looks daunting, but you break it down so simply.
@SalihKocaSK
Ай бұрын
Thank you and your sponsor😎 very much for one more amazing content Chandoo! It is very impressive ! I applied entire solution through your instructions. What I can say, it is not just keep typing formulas, many of those steps requires high mastery skills on how to use that formula in that scenario. Thank you very much again for bringing us into new horizons. With my deepest respects. 👏👏👏
@philym2519
3 ай бұрын
Another great and useful video. Amazing teacher. (Just a point - 27 mins into video, the mention of that if you click out of the cell then formula writing disappears.....the toggle can be used, so when you click between sheets, the writing will not disappear, came by this by chance😄).....thank you for all your tutorials
@MagicOfMushrooms
3 ай бұрын
Thank you Chandoo. This is great information. I'm an analyst and I've been using excel for 20+ years and the LET formula for about a year now and it's changed my life. I think Excel Labs may just take it to the next level. Just downloaded it!
@chandoo_
3 ай бұрын
Glad it was helpful!
@afhlmd
3 ай бұрын
Teacher... that was amazing. This video made me fall in love with Excel again. Thank you so much
@TP014563
3 ай бұрын
Complex formula indeed! I have few of these myself, and I only use them in reports/files where I know that a person wont be asking to constantly change things for them (i.e. new requirements every now and then), because you rightly said at some point in the video, debugging is bit difficult/challenging. I like the arrangement though, especially the 13 weeks trend analysis, very neat!
@skriesten
3 ай бұрын
Thank you, Chandoo. You presentation is provided in such a simple way to follow. It is clear and concise.
@AbdulKamara-t2u
3 ай бұрын
1 question was it possible to VSTACK The headers on top of the Report array to create a fully 1 cell formula and if done that way what are the disadvantages?? I am an advanced excel user of 11 Years and even i learnt ALOT from you today Chandoo !! WOW How can i buy you a coffee this kind of work needs to be appreciated?
@abhishekupadhyay6938
3 ай бұрын
Another amazing video!!! I am very grateful that you share such videos which contains so much useful information freely. I have learned much by watching your videos and every time you teach me something new. Thank you very much for sharing your excellent Excel skills.🙏🙏
@jonesemerson7967
3 ай бұрын
Hi Master Chandoo , my teacher, thanks to keep me update through email and I can watch in detail here. Fantastic and so useful . Enjoy your great life in NZ
@BillSzysz1
3 ай бұрын
Thanks Chandoo 👍👍👍 Maybe it's worth putting the whole thing in a LAMBDA function with three arguments in the form of individual tables? It would be less scary for not very advanced users and more resistant to unwanted actions.
@chandoo_
3 ай бұрын
Yes, we can. As this is a very specific, non-repeating thing, I think a LAMBDA wouldn't be needed. But the AFE makes it easy to convert such formulas to LAMBDAs.
@yashrsingh
3 ай бұрын
Thank you for this video as it helped me to understand some new and functions better.
@frenan82
2 ай бұрын
Thanks a lot. As usual. Best Regards!
@chrism9037
3 ай бұрын
Epic formula, thanks Chandoo!
@pedroemanuelrebelo2182
3 ай бұрын
A very interesting example of the potentialities of the LET function in conjunction with HStack. How can comments be made within the LET function to make it easier to understand?
@hazemali382
2 ай бұрын
always great always Simple
@LokanathReddy-s8y
3 ай бұрын
Thanks for sharing your knowledge to everyone .
@alexbarbucristi
3 ай бұрын
Dude, you're the boss of excel!
@the_ashish_samrat_shorts
3 ай бұрын
Hey chandoo I really like your videos and I never forgot to give you a 👍
@chandoo_
3 ай бұрын
Thank you so much 😀
@Jbooth81583
3 ай бұрын
Hi -- could you explain the LAMBDA -- how does that work? You define "a", then make the 2nd part of the formula equal to a. I don't fully understand whats going on there. Thanks!
@Mehrdad-eb5on
3 ай бұрын
Hi Chandoo Ji, Do you see any changes after wearing braces? I think a year has paste, when are you going to remove them?
@jiskomodo
3 ай бұрын
This is great. I’m currently working on a report that has over 200 tables with data that I need to combine with vstack, then filter and use the reduce function. Is there a million row limit to vstack? Or can I put this into the Let function and it will work?
@chandoo_
3 ай бұрын
If you have such large volume of data, use power pivot and DAX to do you calculations. Formulas will be slow and hard to debug.
@Jbooth81583
3 ай бұрын
Love this!
@sarifulhasan
3 ай бұрын
It's amazing sir... Thank you very much..
@b_rizzle4808
3 ай бұрын
@Chandoo are we able to create a paginated type report with this and lambda recursion?
@chandoo_
3 ай бұрын
Can you elaborate a bit more on what you need?
@weslleyhenrique2989
3 ай бұрын
Amazing!!!
@VinodKumarHyd
3 ай бұрын
Boss, you are the ultimate
@jagatkrishna1543
3 ай бұрын
Thanks 🙏 SIR ❤
@AP-eb8hd
3 ай бұрын
Awesome as usual Purna ..
@musicon1636
3 ай бұрын
chandoo bro google data analyst capstone project gurinchi oka video chei bro
@PhatTony
3 ай бұрын
How to tell if I have Excel 365??
@fabianmorrizz1262
3 ай бұрын
Hi chandoo , will this work in excel 2021 version version built 2045. I am not able to do it , the grid option under excel labs is blank
@chandoo_
3 ай бұрын
I am not sure if all the formulas are available in Excel 2021. I suggest using Excel on the web as most of these should work with that (including Excel labs).
@vijaydiwevdi1304
3 ай бұрын
Thanks sir
@ajithkumar4904
3 ай бұрын
Nice....
@vikeyvikey3149
3 ай бұрын
Guruji❤❤❤❤❤❤❤❤
@rbc13183
3 ай бұрын
At this point, you're basically coding. In such a case, it's important to focus on readability, so I'd recommend more formatting, such as organizing your code blocks into separate lines. That's the first step to making it easy to understand and maintain later. Having this all bunched together with no line breaks (and blank spacing between sections of code) is one of the primary reasons that the formula is so difficult to follow.
@chandoo_
3 ай бұрын
You have to watch the tutorial before making comments like this. The formula is neatly arranged thru advanced editor as shown in the video.
@mapletech_22
3 ай бұрын
Amazon 🎉
@mrbartuss1
3 ай бұрын
The question is WHY?
@EamonnCottrell
3 ай бұрын
There is no why; there is no spoon.
@reanalytics1863
3 ай бұрын
There are multiple reasons why 1: Sorting the entire report is powerful but only possible when the entire report is an array 2 : Filtering an array is more accurate than filtering individual columns
@chandoo_
3 ай бұрын
Because we can. I explain my reasons at the end. It is an interesting experiment. I got to learn many new ways of working with long formulas. Hopefully you got to takeaway something too.
@RonDavidowicz
3 ай бұрын
Because it’s there.
@EamonnCottrell
3 ай бұрын
@@chandoo_ appreciate these epic walkthroughs 👍👍
@arslan_TM
3 ай бұрын
My manager will fire me if he see this thing.
@RonDavidowicz
3 ай бұрын
Genius
@kilapanga
3 ай бұрын
UAU
@MihailBaleev
3 ай бұрын
Top quality content! Totally deserved to be part of an excel conference. Respect 🫡
Пікірлер: 57