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.
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.
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.
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.
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.
Excellent tutorial. Thanks for telling it in such detail.
Thanks!
@@ExcelGoogleSheets how to get this function?
Great and much needed tutorial !
As usual an enlightening explanation of a new function.👍Will this function also be available in the free excel online version?
Can't know for sure, but most likely at some point it will be.
@@ExcelGoogleSheets I'm curious what the update speed of Excel is. 😏
It varies, but mostly between 6 months to a year from initial insider version.
how do you get these functions?? I don't even have lambda. How do I install that particular version?
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.
Hay Sir, this is very best and so functionally uf could be use in google spreadsheet,
can it???
Interesting…can the header of the first table be part of the range? That way I don’t have to copy paste the header.
I like to keep my data separate, but, yea, it should work.
very cool. Like powerquery editor
Sir, is Vstack function available in Google Sheets?
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.
No. Unfortunately Google Sheets hasn't been releasing much lately other than design tweaks.
@@ExcelGoogleSheets Sir, is there any way to achieve the functionality of Lambda function in Google Sheets?
No.
Instead of using multiple IF statements to remove 0s for blanks you can use 1 SUBSTITUTE formula instead and have VSTACK nested inside.
What exactly would that substitute formula look like?
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.
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.
Hi sir, is this possible in google sheet? by the way, excellent tutorial as always!
I've done something similar for Google Sheets here ruclips.net/video/q8awNSYNdq4/видео.html
1st comment and like
You rock!
how do you get these functions?? I don't even have lambda. How do I install that particular version?
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.