Mynda, you have a knack to explain with right examples and this video is no exception! Thank you for helping us learn so much about Excel and related tools, especially the new features! Great work!
I liked how you went straight to point, no additional/unnecessary talking, and no music. Very clearly articulating how the functions work, with their different scenarios. Thank you !!!
I have these new formulas now. Previously, I had Microsoft 365 and Business (2x Microsoft accounts). I had Windows 10 Pro and Windows 11 Pro Preview on another PC. I was a Microsoft Office insider on both PCs and tried everything to get these new formulas somewhere. Well, now I have Windows and 11 Pro on a new PC and after joining Office insider- they worked after the update.
Thanks for sharing; incredible how little I know of excel functions, and each time I watch one of your videos I get the feeling is a never ending endeavor.
Borrowed by @VijayArjunwadkar but TRUE - Mynda, you have a knack to explain with right examples and this video is no exception! Thank you for helping us learn so much about Excel and related tools, especially the new features! Great work!
At around the 5:45 mark you want to include the headers, if the headers are the same as the tables you are stacking use HSTACK to get the header row then stack it on top of the tables like this (if using tables, its easier) =VSTACK(HSTACK(Table1[#Headers]),VSTACK(Table1,Table2,Table3))
Your tutorials are easy to grasp and clearly articulated! Keep it up and keep Excelling ! For the headers, when working with Tables, I find it easier by just adding the header row once --> 𝐕𝐒𝐓𝐀𝐂𝐊(𝐓𝐚𝐛𝐥𝐞𝟏[#𝐇𝐞𝐚𝐝𝐞𝐫𝐬],Table1,Table2,Table3).
Thanks for the video as always. Really like your straightforward style. It's nice to have the flexibility these new functions provide but I have to admit I'm struggling to think of situations where I'd use them over Power Query. Maybe for some really quick and dirty stuff!
@@MyOnlineTrainingHub hey, i am using right now 365 but this option not available so i would like to go 365 beta version but i could to go any video you have. thanks
@@prosenjitchandrapaul These functions are being rolled out. Check if you have updates to install. If they don't appear, give it a few days and check again.
Mynda - I thought it would be the very next example, but was wondering if "Socks" appeared in more than one sheet, would V/X lookup return an array? Guess I'll explore! Thanks for all you do on this channel!!
I have just combined another layer with "=SORT(VSTACK({"Year","Category","Product","Sales"},FILTER(VSTACK('2020:2022'!A2:D6),VSTACK('2020:2022'!A2:A6)"")),4,-1)"
Excellent explanation Mynda, thank you very much! I wonder if one can combine the FILTER function with VSTACK to calculate the sum of the category "Clothing", resulting in a more elegant function than using SUMPRODUCT: =SUM(FILTER(VSTACK('2020:2022'!D2:D6),VSTACK('2020:2022'!B2:B6)="Clothing"))
Hi I watch regularly your videos. I have question trough which tool help me to extract high and low value from multiple excel sheets. Look forward to hear from you soon. Thanks &Regards
Fantastic walkthrough. Can I possibly ask you how I can also solve the following? I have the following formula: =IF(IFERROR(VLOOKUP([@Name],sheet1!A:A,1,FALSE),"No")="No","No","Yes") I need the formula modified to execute the same for 3 sheets within my excel file (sheet1, sheet2, sheet3)
I'm not sure if you want a separate formula in each sheet, or one formula referencing all sheets. Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
Yes, but since spilled arrays don't work in tables, you have to give the spilled array a name and then create a new blank query and use =Excel.CurrentWorkbook() to get the data.
How to keep the black cell still blank instead of “0” using the Vstack? Perhaps on a row only one column does not have an empty cell because there is not a fit criteria.
In this example I had already added the column headers in row 117, but you could also bring them in automatically by increasing the first range in VSTACK to include row 109, which are the header labels for the first range.
I always love your videos, but this one i am struggling with because the =VSTACK(("NAME","REGION","REVENUE"),A2:C6,F2:H7) sits there just like this on the cell returning no results. What am I doing wrong. Hope you are enjoying your first month of spring :)
Is there a reason that VStack and HStack do not show up as available functions/formulas for me, even though I have MS Office 365? I have a definite use for the VStack, but can't seem to get my Excel to recognize it. Thanks!
These functions are being rolled out to the current channel. You might need to update Office or you might be on the semi-annual channel, in which case you’ll have to wait a bit longer, or switch to the current channel.
Hi Johny, that formula only works if the last table in the stack is the one that has empty rows. If it's one of the middle tables you'll see blank rows instead of the zeros, but you can achieve this with number formatting too.
Hello mam please make a VBA macro playlist I need this VBA macro coarse in your channel because your language is very easy and good so please do this what I said please 🙏🏻🙏🏻
Sorry, that still doesn't give me enough information. Perhaps you can post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
Hi Prasanta, they're being rolled out to the 365 current channel. Check if you have an update available. If not, check again in a few days and so on until you get them.
Please try another browser as no one else is reporting issues. Be sure to read the instructions on the page. If you're still having trouble, please reach out via email so we can help troubleshoot: website at MyOnlineTrainingHub.com
Still works for me. You're welcome to post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@MyOnlineTrainingHub thank you i will. Can't post an example because of my work but it's so strange. On a single page it works. But when you reference a second page or 3d ref then it returns a 0 in the cell the formula was entered in. Thanks for the reply and videos always very helpful