Excellent tutorial. Thanks for telling it in such detail.
@ExcelGoogleSheets2 жыл бұрын
Thanks!
@nguonchandy2 жыл бұрын
@@ExcelGoogleSheets how to get this function?
@user123456542 жыл бұрын
Great and much needed tutorial !
@richardhay6452 жыл бұрын
You can put you desired header as the first item in the VSTACK instead of copy paste. I NEVER do a VSTACK without converting all data to tables. I like your demonstration of LAMBDA. Too often LAMDA is taught using pointless, inefficient constructs.
@compjotter25562 жыл бұрын
As usual an enlightening explanation of a new function.👍Will this function also be available in the free excel online version?
@ExcelGoogleSheets2 жыл бұрын
Can't know for sure, but most likely at some point it will be.
@compjotter25562 жыл бұрын
@@ExcelGoogleSheets I'm curious what the update speed of Excel is. 😏
@ExcelGoogleSheets2 жыл бұрын
It varies, but mostly between 6 months to a year from initial insider version.
@teoxengineer2 жыл бұрын
very cool. Like powerquery editor
@vivianrichmusic Жыл бұрын
Instead of using multiple IF statements to remove 0s for blanks you can use 1 SUBSTITUTE formula instead and have VSTACK nested inside.
@ExcelGoogleSheets Жыл бұрын
What exactly would that substitute formula look like?
@datahrd3462 жыл бұрын
Hay Sir, this is very best and so functionally uf could be use in google spreadsheet, can it???
@user-om6tz9us7z7 ай бұрын
Ticket create date : 05/01/2024 09:30 AM, Ticket closing date: 07/01/2024 12:30 PM, I want the total duration but after 09 pm to 09 am i dont want to count the hours, whats the excel formula. please help.
@mrCetus2 жыл бұрын
how do you get these functions?? I don't even have lambda. How do I install that particular version?
@ExcelGoogleSheets2 жыл бұрын
Assuming you are on office 365, under File->Account you have options for updates. If you want all the most recent cool toys you can join Insider program available again under File->Account. Otherwise you can wait a bit and just do a regular update.
@rajeshr8887 Жыл бұрын
Interesting…can the header of the first table be part of the range? That way I don’t have to copy paste the header.
@ExcelGoogleSheets Жыл бұрын
I like to keep my data separate, but, yea, it should work.
@edwinrondina54912 жыл бұрын
Hi sir, is this possible in google sheet? by the way, excellent tutorial as always!
@ExcelGoogleSheets2 жыл бұрын
I've done something similar for Google Sheets here kzbin.info/www/bejne/p2nEqIGJjrOXp5Y
@Al-Ahdal2 жыл бұрын
1st comment and like
@ExcelGoogleSheets2 жыл бұрын
You rock!
@mdrumi6292 жыл бұрын
Sir, is Vstack function available in Google Sheets?
@TheShocobo2 жыл бұрын
this command was first announced by MS on March 16... Seems like MS team is trying to differentiate it from google sheets by creating new functions available only in Excel.
@ExcelGoogleSheets2 жыл бұрын
No. Unfortunately Google Sheets hasn't been releasing much lately other than design tweaks.
@mdrumi6292 жыл бұрын
@@ExcelGoogleSheets Sir, is there any way to achieve the functionality of Lambda function in Google Sheets?
@ExcelGoogleSheets2 жыл бұрын
No.
@iiiiii-w8h2 жыл бұрын
how do you get these functions?? I don't even have lambda. How do I install that particular version?
@ExcelGoogleSheets2 жыл бұрын
Assuming you are on office 365, under File->Account you have options for updates. If you want all the most recent cool toys you can join Insider program available again under File->Account. Otherwise you can wait a bit and just do a regular update.