VSTACK Excel - Quickly Combine Data from Multiple Sheets (Excel Noob Vs Pro)
Жүктеу.....
Пікірлер: 618
@LeilaGharani6 ай бұрын
Grab the file I used in the video from here 👉 pages.xelplus.com/vstack-file
@user-is5zs1qw1x
4 ай бұрын
Hello Leila! Thanks a million for your teaching materials, they are helpful. I have a question: After combining sheets with VSTACK, I can't turn the data into an Excel Table. Why is it so? What can I do to keep the data Dynamic? Thank you for your feedback!
@Alkamanojofficial
3 ай бұрын
Whast about version of Excel?
@pdrg2 жыл бұрын
Then the Regional Manager arrived and didn't even look at it...
@magnushultgrenhtc
2 жыл бұрын
My thoughts exactly. "We're running two minutes late and will have to cut the presentation."
@soft.learning
2 жыл бұрын
It happens sometime
@usmanahmed5854
Жыл бұрын
😂
@LetsCOLORup
Жыл бұрын
Lol
@amoorinet..
Жыл бұрын
Far from the main purpose of reports which is documentation I don't know what the size of the company you work for, but as a professional management approach, top position people prefer short reports. An example in the field of construction in which I work is that area managers are interested in achieving the Milestone without details, and project managers are interested in achieving a number of activities without details. And construction managers are the ones who care about this huge amount of reports.
@texian21122 жыл бұрын
Why isn’t there a love button? As always thanks for this valuable productivity hack. Keep doing what you do Leila. Love this and all your other posts.
@cruzinsweetsntreats
2 жыл бұрын
There is from the content creator, such as Leila, but not from us, as I too, would like to respond as such on numerous others. 🤟💌😍
@RenierWessels2 жыл бұрын
This was awesome Leila. Being able to showcase all of that in under 7 minutes is pretty amazing. I struggle with keeping my videos short myself. The production value of your content is amazing. Well done.
@LeilaGharani
2 жыл бұрын
Thank you Renier. You have great videos on your channel.
@RenierWessels
2 жыл бұрын
@@LeilaGharani thank you. I appreciate your reply!! Keep up the great work.
@truthByFire
2 жыл бұрын
This channel is fantastic. Great content!
@dheerajy2202
2 жыл бұрын
@@LeilaGharani big 🧢
@Idiot123009
2 жыл бұрын
@@LeilaGharani Leila Gharani is always amazing. Excellent and precise on topic. Excellently explained. Always pray for you.
@chh88602 жыл бұрын
VSTACK??? ... I'm speechless ... another stunning display of Excel mastery ... Some people look forward to Friday's ... I look forward to Thursdays ... w/Leila ... 😍 PS " ... we just had to switch things up for a change ... let me know what you thought about it ..." 😞 ... 🥱 ... 😴 ...
@LeilaGharani
2 жыл бұрын
Thank you for still looking forward to Thursdays! Even after all this time.
@roderickmose46912 жыл бұрын
"Hold my coffee".......just gotta love the lady! Excellent and creative as always. Well done again, Leila!
@michebernier52982 жыл бұрын
Thank you so much for this video, it was great reminder that formulas can be built with main intent, then sub requests added in as they were requested, all too often many of us build the formula from the beginning to the end, and forget we accomplish one goal, then add another goal, and so forth. Example, delivery and content was fantastic -- Thank you !
@tommyriddley81292 жыл бұрын
I have been following you and it has resulted in me signing up for your courses on Udemy. Although I have to take several attempts at the lessons it is great using your practice files so I can concentrate on developing my understanding of the functions. Thanks for sharing your knowledge.
@loganwebb13382 жыл бұрын
I loved this! I am relatively novice with excel but I've learned a massive amount from you. I found the other day that I did not know how to stack data without manual copy pasting and have been trying to figure that out for nearly a month. Thank you for showing this vstack formula!
@ashutoshaurum10 ай бұрын
Whenever I KZread a problem on Excel and it's your video, I know it is the best of the lot. Thanks for the wonderful explanation!.
@Cappurnikus2 жыл бұрын
Very cool function. Thanks for sharing! I recently solved this same scenario but with VBA. It was a very small loop but also considered the last row of each sheet to ensure there will never be missed info. Thanks again!
@carlosd.villanuevaa.38332 жыл бұрын
Great video, Leila! It helped us, the crowd, better understand these functions that, otherwise, can be difficult to explain in general terms. Thank you so much for putting this content!
@hectorbrac1002 жыл бұрын
This is amazing Leila! I wished I had seen your video a few months ago when I had to figure this out on my own by try and error yet though I came to the same set of formulas I realized that doing so in Power query was less messier and more customizable. It's still great to know that the same result can be achieved in different ways
@PurplePegasus25312 жыл бұрын
THANK YOU SO MUCH!! I was literally just having this issue at work and now I can use this in real time! You're so great at making excel accessible! You're making me a superstar at work
@mamachugh11252 жыл бұрын
This is fabulous Leila! I always appreciate your tutorials. Short and sweet, as always.
@LeilaGharani
2 жыл бұрын
Thank you so much!
@Hey_Dave2 жыл бұрын
Love the switch-up!! Amazing! I always learn something new from your videos.
@rodrigodiaz1558Ай бұрын
I knew there was some way more simple that the index formula stuff that honestly make my head hurt, THANKS LEILA!!!
@rob4canada2 жыл бұрын
Loved the new video style and explanation of VSTACK and how it could be used in a real world example.
@nathanmclauchlan51482 жыл бұрын
Wow. Amazing. Thanks so much, you made it rather easy to combine data from multiple sheets, remove blank rows and sort the data
@JNguyenKnight2 жыл бұрын
Yet another great video. I've subscribed to your videos and courses for a while now, and with each one, I come away with so many new ideas on how to improve my spreadsheets and project workflow. I like most how you mix and match the various of functions in Excel to accomplish results that are applicable and transferrable to so many different situations. I love the way you think and explain. And mostly, thank you for continuuing to inspire creative problem-solving to make work easier.
@igortorrealba2 жыл бұрын
Looooove this format Layla! I encourage you to consider doing more like this!!!
@spacedudey2k Жыл бұрын
Fantastic tutorial. And I think I will use this on a project I’m working on currently. Thank you, Leila.
@Cdaddyx12122 жыл бұрын
Honestly I always thought I was quite advanced in Excel but it is amazing how you overlook small things that can actually be very useful. Thank you so much Leila for your videos and especially how you go through the formulas in a step by step way so it is easy enough for me to keep up. I learned more from you than the official advanced classroom training I had.
@LeilaGharani
2 жыл бұрын
Thank you for the kind feedback!
@thierryhoornaert99502 жыл бұрын
Thank you, Leila. This is great stuff and a real time saver!
@JeremyMcMahan2 жыл бұрын
Fun video! The part about sorting with two columns and the curly braces for ASC/DESC was gold!
@HANSMKAMP11 ай бұрын
I love that!! Both the way the video is made, and its contents. Also the strength of VSTACK, FILTER and SORT!
@jamesgriffin7732 жыл бұрын
Thank you for this heads up. This is a function I really want. For a long time iferror was the life changing function. Sumifs came along. Then the dynamic arrays improved my life. This will solve so many questions from auditors.
@luisfeps2 жыл бұрын
Thanks from Brazil. Amazing videos with so dynamic teaching techniques.
@javer11 Жыл бұрын
Leila you saved me again! ❤ Thank you. Will find some time to study your power query videos soon, for now, this is all that I needed😘 God bless you❤️
@snicho2 жыл бұрын
Ah, it's a beautiful thing! A great practical example. A good use of combining functions. Well presented. And the format works well too. :)
@drag0nblight Жыл бұрын
I have learned a lot from this channel. I am actually using some of them for my sideline gig. No more looking up on a list on paper, just Excel.
@efs83dws2 жыл бұрын
Very good presentation. You are the best on KZread for presenting Excel functions and features.
@chrism90372 жыл бұрын
Thanks Leila! I still don''t have VSTACK but can't wait to get this and other new functions.
@ezewong290 Жыл бұрын
This is amazing, I've been doing filter functions within the vstack and not the other way around. ALSO, 3d array... amazing exceptionally informative. Thank you
@abdulsaidmkamara73052 жыл бұрын
Leila Gharani !!! She does it again Thank you !! I will be implementing this soon, You have taken by the hand from a below average excel user to Finance Executive level execution in a few months. You are one of the best things to happen to my career.
@LeilaGharani
2 жыл бұрын
Thank you Abdul! You've done the hard work. I'm glad to be a part of that.
@NoTengoIlusiones2 жыл бұрын
Love the video. Sense of humor and useful as always . A big and fat like !
@ujjwaldeo67702 жыл бұрын
OMG😲 I had no clue about this before today. In actual tasks on our jobs, things would be so much easier...just using this, esp. the VSTACK....simply wow👌. Thanks Leila👍🏻
@LeilaGharani
2 жыл бұрын
You are so welcome!
@AmitRoy-om3tp2 жыл бұрын
Awesome video! It helped me consolidate the data from multiple sheets. Great, Leila!
@mattschoular88442 жыл бұрын
Thanks Leila...The video format was good. It explained a hypothetical real world example nicely.
@kenhappich90322 жыл бұрын
As always your presentations are so extremely informative and I love how add the humorous theatrical drama. Your presentations are definitely polished !!!
@michaellucas7177
2 жыл бұрын
Wish I could thumbs-up this like ten times!!!!
@Ticky66MN2 жыл бұрын
Dang, that was an awesome video. Love the style and the resulting education...very impressive. Thank you.
@AQmanchamoli2 жыл бұрын
Great Leila !! i have no clue about this function availability so far....it surely gonna help in filing my GB certification in my Organisation ❤️ more power to u and happy learning together 💕
@dagnabit278512 жыл бұрын
This is amazing! Side note: I'm the noob who didn't know you could drag and drop tabs from a different file so I learned quite a bit in this video.
@LeilaGharani
2 жыл бұрын
Glad you liked it :)
@a.achirou6547 Жыл бұрын
This is fantastic Leila. That caught my attention all along !! Thank you.
@michaelsiggers4109 Жыл бұрын
Superb video with so many features. Plenty of information I can use and adapt. Thankyou.
@sonialorenzo92232 жыл бұрын
Love your instructions, short and clear.
@pwells23892 жыл бұрын
Really enjoyed your helium voice for the newbie :) Great info too. I've been using Excel for ages and didn't know about the 3D worksheet referencing (I thought that was dead with Lotus 123) or the { bracket feature. Many thanks.
@SamOlliver2 жыл бұрын
Thanks Leila, your videos never cease to be useful and informative! 😀
@LeilaGharani
2 жыл бұрын
Thank you, Sam!
@kimbereleybrown9449 Жыл бұрын
Thank you! This was so helpful and easy to understand.
@BEDSTUYKEV313 ай бұрын
2 snaps up. Thank you! I needed a workaround from PowerQuery since I had to consolidate worksheets in non-table format
@vivekpachisia51982 жыл бұрын
Superb Leila, awesome this function is and u explained in a very easy way. Thank u very much
@dvboy2 жыл бұрын
This is a game changer for me, learning how to vstack and filter. Thank you!
@hussainakhtar1094 Жыл бұрын
This is just a master blaster... I love using these tricks, playing around, and doing analysis with data. The beauty of the array functions is that the file size does not increase significantly.. Thank you Laila awesome stuff.
@LeilaGharani
Жыл бұрын
Glad you enjoy it!
@hussainakhtar1094
Жыл бұрын
@@LeilaGharani I have used these on inventory sheets and it worked awesome
@loudodson2 жыл бұрын
You are an absolutely wonderful person! This was a perfectly timed video. You solved a problem I have been working on for the last 2 days. Thanks for the great work and insights.
@LeilaGharani
2 жыл бұрын
Glad it was helpful!
@ulrickt2 жыл бұрын
This video is hilarious! And also very good in terms of the actual content, I'm sure this can be very helpful. I'm unsure if I think this should be the general format for new videos but I found it really funny in terms of mixing it up. Thank you.
@samanthadaroga4811 Жыл бұрын
This was a great video. Very helpful! Thank you kindly.
@covali692 жыл бұрын
I like many of your videos, this one I really really appreciate! Because it is helpful to some tasks I do, and also the fresh presentation style. Situation - Question (what if?) - solution/option
@GenNextAnalyst2 жыл бұрын
solution-based presentation! Very useful! Thanks Leila
@isamjafar36402 жыл бұрын
Wow! I didn't realise yo can do this; it will save me so much time at work! Thank you for sharing Leila.
@superohitupadhyay2 жыл бұрын
I feel superman among my colleagues, I have gone through all your videos on UDEMY as well as KZread, many thanks for making our job easier, more power to you, and about your acting style in this video, since your content is so informative you don’t need it, however it’s making video more interesting.. Thanks (your follower from India)..
@sarahmclin2434 Жыл бұрын
My boss suggested I check out your channel to learn some of the newer excel features. I am so glad he did! I loved this video.
@DinoDelight2 жыл бұрын
Another great explanation, im still waiting for vstack. I did not know you can drag and drop a tab from another workbook....that's gonna save me a massive amount of time
@kelechie.20112 жыл бұрын
Your videos rock!!! Straight to the point and easy to understand
@mktindogrosir3539 Жыл бұрын
this video is amazing, really open my eyes there are still a lot fuction that can help me outm thank you so much
@MrRoelith2 жыл бұрын
Crazy helpful. Thank you!
@zolnog2 жыл бұрын
Informative and entertaining. Thanks, Leila, you make it fun.
@Luciano_mp2 жыл бұрын
Very good Leila. I liked! Thank you.
@shelleygower47482 жыл бұрын
Brilliant, you explain things so perfectly.
@gurudattkeshav2 жыл бұрын
This is the best one for me so far! Thanks Leila
@hiteshbhatia7872 жыл бұрын
Big fan of urs....as always u bring the solution of problems with dynamic formulas and building dynamic environment in Excel....
@crashman3210 Жыл бұрын
Great video, well put together and engaging! A massive help thank you!
@MiRofek2 жыл бұрын
Great tutorial Leila (as always)!
@Rice09872 жыл бұрын
And this formula is too interesting, so surely i'll try it tomorrow! THANKS Leila! :)
@bellondayako4162 Жыл бұрын
Loved the way tutorial was presented.
@GurayVural-nz1lk Жыл бұрын
An impressive video! Thanks a lot for the tips.
@thenotidevil2 жыл бұрын
It was just awesome as all your videos. Thanks for sharing and guiding us with all this knowledge.
@LeilaGharani
2 жыл бұрын
My pleasure!
@alterchannel2501 Жыл бұрын
WOW. Thanks so much for this. You're Great.
@tianyi052 жыл бұрын
Finally Excel gets this function, Lotus123 had it back in the early 1990's, except sheets in Lotus didn't have to be identically laid out, columns in sheets could be in any order and some sheets could have extra columns, also could add rows to individual sheets as definition of the array was dynamic.
@RichardJones732 жыл бұрын
You've excelled yourself again Leila, Queen of Excel
@riansyahsumajaya2 жыл бұрын
My goodness this is why i subcribed to you. Excellent demonstration to show when this type of formulas will be used. Thanks Leila for these types of videos, really bring inspirations.
@LeilaGharani
2 жыл бұрын
Thank you Riansyah! I'm glad to hear that.
@msrchannel472111 ай бұрын
Thank you very much. Your videos are very helpful.
@algriff212 жыл бұрын
I've been looking to up my macro & VBA and this video has done the job! Also, just clicked to be a subscriber. Looking forward to browsing your catalog of videos.
@truthByFire2 жыл бұрын
This channel is fantastic. Great content!
@officialpreside102 жыл бұрын
Wow. You never disappoint. Weldone Ma'am
@joeyoukhanna65192 жыл бұрын
Thanks a million, Leila, always charming, 100% love it.
@amagdenovski2 жыл бұрын
Incredibly helpful!
@brianbrinegar60862 жыл бұрын
Awesome video! Fun format. :)
@rockymarquiss83272 жыл бұрын
I enjoyed the format and the information is good as well
@lucasb409 Жыл бұрын
I have been struggling with using the filter function wrapped on VSTACK until I noticed something. I MISSED the fact your condition was for only 1 column, not the whole row. My Value# error is gone and it works! My project is saved. Thank you!
@Q8Patriot Жыл бұрын
Thats were too helpful, thanks alot for sharing😊
@SuperAshraf19722 жыл бұрын
Awesome... I like it. Thx a lot Leila.
@Sami-rp7mf Жыл бұрын
Great info may need to use this sometimes.TY
@nokia20132 жыл бұрын
Thanks for the latest improvements, 365 has some revolutionary features.
@82MMaarrkkuuSS822 жыл бұрын
Once again... AWESOME Leila!!! thank you very much!!!
@LeilaGharani
2 жыл бұрын
Glad you like it!
@voiceofsoul7865 Жыл бұрын
Leila, your videos are as beautiful as you are. I am getting much knowledge from your videos, and your teaching style is also awesome.
@lucyene50602 жыл бұрын
😱😱OMG... I'll try on my report now You're amazing!!!!!🤗🤗
@shehubilyaminuroro2 жыл бұрын
Hi Laila. This video is great, because it helps me in organizing different report from my Sales Representatives. We appreciate.
@LeilaGharani
2 жыл бұрын
That's great to hear!
@andrewcharlesmoss2 жыл бұрын
Great acting skills, Leila!
@lankavenkatasuri7388 Жыл бұрын
Very beautiful functions.. Very very useful classic method..
@fernsehdesign Жыл бұрын
I like the voice of the Noob especially. Cute realistic drama that you created there. Looking forward to the next episode.
Пікірлер: 618
Grab the file I used in the video from here 👉 pages.xelplus.com/vstack-file
@user-is5zs1qw1x
4 ай бұрын
Hello Leila! Thanks a million for your teaching materials, they are helpful. I have a question: After combining sheets with VSTACK, I can't turn the data into an Excel Table. Why is it so? What can I do to keep the data Dynamic? Thank you for your feedback!
@Alkamanojofficial
3 ай бұрын
Whast about version of Excel?
Then the Regional Manager arrived and didn't even look at it...
@magnushultgrenhtc
2 жыл бұрын
My thoughts exactly. "We're running two minutes late and will have to cut the presentation."
@soft.learning
2 жыл бұрын
It happens sometime
@usmanahmed5854
Жыл бұрын
😂
@LetsCOLORup
Жыл бұрын
Lol
@amoorinet..
Жыл бұрын
Far from the main purpose of reports which is documentation I don't know what the size of the company you work for, but as a professional management approach, top position people prefer short reports. An example in the field of construction in which I work is that area managers are interested in achieving the Milestone without details, and project managers are interested in achieving a number of activities without details. And construction managers are the ones who care about this huge amount of reports.
Why isn’t there a love button? As always thanks for this valuable productivity hack. Keep doing what you do Leila. Love this and all your other posts.
@cruzinsweetsntreats
2 жыл бұрын
There is from the content creator, such as Leila, but not from us, as I too, would like to respond as such on numerous others. 🤟💌😍
This was awesome Leila. Being able to showcase all of that in under 7 minutes is pretty amazing. I struggle with keeping my videos short myself. The production value of your content is amazing. Well done.
@LeilaGharani
2 жыл бұрын
Thank you Renier. You have great videos on your channel.
@RenierWessels
2 жыл бұрын
@@LeilaGharani thank you. I appreciate your reply!! Keep up the great work.
@truthByFire
2 жыл бұрын
This channel is fantastic. Great content!
@dheerajy2202
2 жыл бұрын
@@LeilaGharani big 🧢
@Idiot123009
2 жыл бұрын
@@LeilaGharani Leila Gharani is always amazing. Excellent and precise on topic. Excellently explained. Always pray for you.
VSTACK??? ... I'm speechless ... another stunning display of Excel mastery ... Some people look forward to Friday's ... I look forward to Thursdays ... w/Leila ... 😍 PS " ... we just had to switch things up for a change ... let me know what you thought about it ..." 😞 ... 🥱 ... 😴 ...
@LeilaGharani
2 жыл бұрын
Thank you for still looking forward to Thursdays! Even after all this time.
"Hold my coffee".......just gotta love the lady! Excellent and creative as always. Well done again, Leila!
Thank you so much for this video, it was great reminder that formulas can be built with main intent, then sub requests added in as they were requested, all too often many of us build the formula from the beginning to the end, and forget we accomplish one goal, then add another goal, and so forth. Example, delivery and content was fantastic -- Thank you !
I have been following you and it has resulted in me signing up for your courses on Udemy. Although I have to take several attempts at the lessons it is great using your practice files so I can concentrate on developing my understanding of the functions. Thanks for sharing your knowledge.
I loved this! I am relatively novice with excel but I've learned a massive amount from you. I found the other day that I did not know how to stack data without manual copy pasting and have been trying to figure that out for nearly a month. Thank you for showing this vstack formula!
Whenever I KZread a problem on Excel and it's your video, I know it is the best of the lot. Thanks for the wonderful explanation!.
Very cool function. Thanks for sharing! I recently solved this same scenario but with VBA. It was a very small loop but also considered the last row of each sheet to ensure there will never be missed info. Thanks again!
Great video, Leila! It helped us, the crowd, better understand these functions that, otherwise, can be difficult to explain in general terms. Thank you so much for putting this content!
This is amazing Leila! I wished I had seen your video a few months ago when I had to figure this out on my own by try and error yet though I came to the same set of formulas I realized that doing so in Power query was less messier and more customizable. It's still great to know that the same result can be achieved in different ways
THANK YOU SO MUCH!! I was literally just having this issue at work and now I can use this in real time! You're so great at making excel accessible! You're making me a superstar at work
This is fabulous Leila! I always appreciate your tutorials. Short and sweet, as always.
@LeilaGharani
2 жыл бұрын
Thank you so much!
Love the switch-up!! Amazing! I always learn something new from your videos.
I knew there was some way more simple that the index formula stuff that honestly make my head hurt, THANKS LEILA!!!
Loved the new video style and explanation of VSTACK and how it could be used in a real world example.
Wow. Amazing. Thanks so much, you made it rather easy to combine data from multiple sheets, remove blank rows and sort the data
Yet another great video. I've subscribed to your videos and courses for a while now, and with each one, I come away with so many new ideas on how to improve my spreadsheets and project workflow. I like most how you mix and match the various of functions in Excel to accomplish results that are applicable and transferrable to so many different situations. I love the way you think and explain. And mostly, thank you for continuuing to inspire creative problem-solving to make work easier.
Looooove this format Layla! I encourage you to consider doing more like this!!!
Fantastic tutorial. And I think I will use this on a project I’m working on currently. Thank you, Leila.
Honestly I always thought I was quite advanced in Excel but it is amazing how you overlook small things that can actually be very useful. Thank you so much Leila for your videos and especially how you go through the formulas in a step by step way so it is easy enough for me to keep up. I learned more from you than the official advanced classroom training I had.
@LeilaGharani
2 жыл бұрын
Thank you for the kind feedback!
Thank you, Leila. This is great stuff and a real time saver!
Fun video! The part about sorting with two columns and the curly braces for ASC/DESC was gold!
I love that!! Both the way the video is made, and its contents. Also the strength of VSTACK, FILTER and SORT!
Thank you for this heads up. This is a function I really want. For a long time iferror was the life changing function. Sumifs came along. Then the dynamic arrays improved my life. This will solve so many questions from auditors.
Thanks from Brazil. Amazing videos with so dynamic teaching techniques.
Leila you saved me again! ❤ Thank you. Will find some time to study your power query videos soon, for now, this is all that I needed😘 God bless you❤️
Ah, it's a beautiful thing! A great practical example. A good use of combining functions. Well presented. And the format works well too. :)
I have learned a lot from this channel. I am actually using some of them for my sideline gig. No more looking up on a list on paper, just Excel.
Very good presentation. You are the best on KZread for presenting Excel functions and features.
Thanks Leila! I still don''t have VSTACK but can't wait to get this and other new functions.
This is amazing, I've been doing filter functions within the vstack and not the other way around. ALSO, 3d array... amazing exceptionally informative. Thank you
Leila Gharani !!! She does it again Thank you !! I will be implementing this soon, You have taken by the hand from a below average excel user to Finance Executive level execution in a few months. You are one of the best things to happen to my career.
@LeilaGharani
2 жыл бұрын
Thank you Abdul! You've done the hard work. I'm glad to be a part of that.
Love the video. Sense of humor and useful as always . A big and fat like !
OMG😲 I had no clue about this before today. In actual tasks on our jobs, things would be so much easier...just using this, esp. the VSTACK....simply wow👌. Thanks Leila👍🏻
@LeilaGharani
2 жыл бұрын
You are so welcome!
Awesome video! It helped me consolidate the data from multiple sheets. Great, Leila!
Thanks Leila...The video format was good. It explained a hypothetical real world example nicely.
As always your presentations are so extremely informative and I love how add the humorous theatrical drama. Your presentations are definitely polished !!!
@michaellucas7177
2 жыл бұрын
Wish I could thumbs-up this like ten times!!!!
Dang, that was an awesome video. Love the style and the resulting education...very impressive. Thank you.
Great Leila !! i have no clue about this function availability so far....it surely gonna help in filing my GB certification in my Organisation ❤️ more power to u and happy learning together 💕
This is amazing! Side note: I'm the noob who didn't know you could drag and drop tabs from a different file so I learned quite a bit in this video.
@LeilaGharani
2 жыл бұрын
Glad you liked it :)
This is fantastic Leila. That caught my attention all along !! Thank you.
Superb video with so many features. Plenty of information I can use and adapt. Thankyou.
Love your instructions, short and clear.
Really enjoyed your helium voice for the newbie :) Great info too. I've been using Excel for ages and didn't know about the 3D worksheet referencing (I thought that was dead with Lotus 123) or the { bracket feature. Many thanks.
Thanks Leila, your videos never cease to be useful and informative! 😀
@LeilaGharani
2 жыл бұрын
Thank you, Sam!
Thank you! This was so helpful and easy to understand.
2 snaps up. Thank you! I needed a workaround from PowerQuery since I had to consolidate worksheets in non-table format
Superb Leila, awesome this function is and u explained in a very easy way. Thank u very much
This is a game changer for me, learning how to vstack and filter. Thank you!
This is just a master blaster... I love using these tricks, playing around, and doing analysis with data. The beauty of the array functions is that the file size does not increase significantly.. Thank you Laila awesome stuff.
@LeilaGharani
Жыл бұрын
Glad you enjoy it!
@hussainakhtar1094
Жыл бұрын
@@LeilaGharani I have used these on inventory sheets and it worked awesome
You are an absolutely wonderful person! This was a perfectly timed video. You solved a problem I have been working on for the last 2 days. Thanks for the great work and insights.
@LeilaGharani
2 жыл бұрын
Glad it was helpful!
This video is hilarious! And also very good in terms of the actual content, I'm sure this can be very helpful. I'm unsure if I think this should be the general format for new videos but I found it really funny in terms of mixing it up. Thank you.
This was a great video. Very helpful! Thank you kindly.
I like many of your videos, this one I really really appreciate! Because it is helpful to some tasks I do, and also the fresh presentation style. Situation - Question (what if?) - solution/option
solution-based presentation! Very useful! Thanks Leila
Wow! I didn't realise yo can do this; it will save me so much time at work! Thank you for sharing Leila.
I feel superman among my colleagues, I have gone through all your videos on UDEMY as well as KZread, many thanks for making our job easier, more power to you, and about your acting style in this video, since your content is so informative you don’t need it, however it’s making video more interesting.. Thanks (your follower from India)..
My boss suggested I check out your channel to learn some of the newer excel features. I am so glad he did! I loved this video.
Another great explanation, im still waiting for vstack. I did not know you can drag and drop a tab from another workbook....that's gonna save me a massive amount of time
Your videos rock!!! Straight to the point and easy to understand
this video is amazing, really open my eyes there are still a lot fuction that can help me outm thank you so much
Crazy helpful. Thank you!
Informative and entertaining. Thanks, Leila, you make it fun.
Very good Leila. I liked! Thank you.
Brilliant, you explain things so perfectly.
This is the best one for me so far! Thanks Leila
Big fan of urs....as always u bring the solution of problems with dynamic formulas and building dynamic environment in Excel....
Great video, well put together and engaging! A massive help thank you!
Great tutorial Leila (as always)!
And this formula is too interesting, so surely i'll try it tomorrow! THANKS Leila! :)
Loved the way tutorial was presented.
An impressive video! Thanks a lot for the tips.
It was just awesome as all your videos. Thanks for sharing and guiding us with all this knowledge.
@LeilaGharani
2 жыл бұрын
My pleasure!
WOW. Thanks so much for this. You're Great.
Finally Excel gets this function, Lotus123 had it back in the early 1990's, except sheets in Lotus didn't have to be identically laid out, columns in sheets could be in any order and some sheets could have extra columns, also could add rows to individual sheets as definition of the array was dynamic.
You've excelled yourself again Leila, Queen of Excel
My goodness this is why i subcribed to you. Excellent demonstration to show when this type of formulas will be used. Thanks Leila for these types of videos, really bring inspirations.
@LeilaGharani
2 жыл бұрын
Thank you Riansyah! I'm glad to hear that.
Thank you very much. Your videos are very helpful.
I've been looking to up my macro & VBA and this video has done the job! Also, just clicked to be a subscriber. Looking forward to browsing your catalog of videos.
This channel is fantastic. Great content!
Wow. You never disappoint. Weldone Ma'am
Thanks a million, Leila, always charming, 100% love it.
Incredibly helpful!
Awesome video! Fun format. :)
I enjoyed the format and the information is good as well
I have been struggling with using the filter function wrapped on VSTACK until I noticed something. I MISSED the fact your condition was for only 1 column, not the whole row. My Value# error is gone and it works! My project is saved. Thank you!
Thats were too helpful, thanks alot for sharing😊
Awesome... I like it. Thx a lot Leila.
Great info may need to use this sometimes.TY
Thanks for the latest improvements, 365 has some revolutionary features.
Once again... AWESOME Leila!!! thank you very much!!!
@LeilaGharani
2 жыл бұрын
Glad you like it!
Leila, your videos are as beautiful as you are. I am getting much knowledge from your videos, and your teaching style is also awesome.
😱😱OMG... I'll try on my report now You're amazing!!!!!🤗🤗
Hi Laila. This video is great, because it helps me in organizing different report from my Sales Representatives. We appreciate.
@LeilaGharani
2 жыл бұрын
That's great to hear!
Great acting skills, Leila!
Very beautiful functions.. Very very useful classic method..
I like the voice of the Noob especially. Cute realistic drama that you created there. Looking forward to the next episode.