'Dated if' has been there for so long in circulation, but you read the developers mind who created this - he/she called it 'Date-Dif' 👍👍 As that is what this built-in function is for 😁
You are bright and easy to follow. I'm already applying these functions in production. Plus, I already DWNLD the Analytics guide today. Will see all your vids. Thank you
To extract the Emails, you can use Ai.Extract formula better as you explained it in previous video. I would like to thank you, i learn from you a lot ❤❤
Dear Kenji, Spilled formula and with a header it is better: =REDUCE({"First Name","Last Name","Age","Outcome"},B3:B14,LAMBDA(a,b,VSTACK(a,TEXTSPLIT(b,{" ",", "},,1)))) And TEXTJOIN with the right delimiters is better too: =TEXTJOIN({" ";", ";", "},,C3#) 🤗
Hey I'm using microsoft365 (but I also get early access to some formulas before they're released to the general public). Many of these (except regex i think) should be available in microsoft365 already
From my understanding the new functions and features they roll out are generally for Office 365. That is one of the advantages of the subscription service.
Guys! Today I noticed something supper odd. And now I wander was it always like this? Here's the issue/bug: in both Excel and GSheets the COUNT(range) and COUNTIF(range, "") formulas are counting the cells even if they have formula that outputs "" Blank results! WHATA HACK IS EVEN THAT?!
Datedif is not new, it is just like Excel’s illegitimate child that came to light, It is so neglected that there is no helper text/explanation for the arguments, they don’t even bother to standardize the same keyword in VBA (Datediff), and the arguments also in the wrong order. It is a formula/command that would be useful for a newbie, yet only be told much later on when it is no longer in need.
🚀Get the FREE Data Analytics Guide from Hubspot: clickhubspot.com/1c5
Beautiful, thank you Kenji.
The TAKE + SORT + CHOOSECOLS is very helpful.
I still think the function should be called "DATE-DIF," not "DATED-IF"
I assume Kenji is dating someone. 😂
Agreed! I do call it DATE-DIF 😊
I am with you, there is no condition attached to the function, why would someone say dated if 😂
'Dated if' has been there for so long in circulation, but you read the developers mind who created this - he/she called it 'Date-Dif' 👍👍
As that is what this built-in function is for 😁
You are bright and easy to follow. I'm already applying these functions in production. Plus, I already DWNLD the Analytics guide today. Will see all your vids. Thank you
Good to know, that the TEXTSPLIT function can take a list of delimiters as an argument and not only one. That was new for me👍
These combination of Take, Sort and Choosecol can be use as alternative of GSheet Query on Excel,
A real game changer on Excel formulas,
Thanks!
Thanks for watching! :)
Nice demonstrations of some amazing new features. The capability of Excel is now unbelievable.
Kenji, your videos are brilliant! Crisp and absolutely easy to follow👌🏽🙏🏽
To extract the Emails, you can use Ai.Extract formula better as you explained it in previous video. I would like to thank you, i learn from you a lot ❤❤
It seems we are not even using 10% of excel functions. Thanks for the info
Really your taking us to super levels, than and many thanks
Dear Kenji,
Spilled formula and with a header it is better:
=REDUCE({"First Name","Last Name","Age","Outcome"},B3:B14,LAMBDA(a,b,VSTACK(a,TEXTSPLIT(b,{" ",", "},,1))))
And TEXTJOIN with the right delimiters is better too:
=TEXTJOIN({" ";", ";", "},,C3#) 🤗
Thanks. Can you do a video in comparing 1st and 2nd and what is the easiest:best way to extract difference?
Thank you for this. I am wondering which tools you are using for making this wonderful videos.
correction : "Really you are taking us to super levels, thanks and many thanks"
Really great tricks!! Thanks!!
Is regex under beta version? Coz as an employe with subscription to ms365 I am no getting the =regex while using. Can anyone help how to enable
create a regex to help me identify if there are numbers in a list of
Just wow..
do you know if the AI one will become a part of Excel (not an addin) at some point?
I don't know tbh!
Hello Kenji, please share Excel version you are using with those updated formula.
I need that .exe file to be on same page with you
Hey I'm using microsoft365 (but I also get early access to some formulas before they're released to the general public). Many of these (except regex i think) should be available in microsoft365 already
will all this work in MS Office Home or only for MS 365?
Hey I'm not too familiar with MS Office Home tbh so I can't comment. I'm currently on MS365
From my understanding the new functions and features they roll out are generally for Office 365. That is one of the advantages of the subscription service.
Handsome kenji
thank you lol hopefully the video was useful XD
My excel not showing new formulas pls help me to get results
Sir from where should I download free updated MS Office for long time
My download and your video file did not match, I had country and units sold columns
I Still don´t have these functions and my account is an insider one. What can I do to have them? Already updated excel several times.
I too don't have the choose cols formula
What version of Excel are you using?
2021
2024
Microsoft 365 or
Office 365?
Column A
Chemistry
Biotech, Chemistry
Physics
Column B
Q1
Q3
Q1
I want pivot table result as below
Chemistry Q1 (count 1) Q3 (count 1)
Biotech Q3 (count 1)
Physics Q1(count 1)
Hit the Tab key thereee.
Datedif was canceled as official formula because, in verry specific conditions, it may give an incorrect result
Alex Megos 👀
Hahha glad you noticed XD
Guys! Today I noticed something supper odd. And now I wander was it always like this? Here's the issue/bug: in both Excel and GSheets the COUNT(range) and COUNTIF(range, "") formulas are counting the cells even if they have formula that outputs "" Blank results!
WHATA HACK IS EVEN THAT?!
4:24
=C3& " " & D3 & "," & E3 & "," & F3
Result will be - Kylee Townsen,56,Pass
Datedif is not new, it is just like Excel’s illegitimate child that came to light,
It is so neglected that there is no helper text/explanation for the arguments,
they don’t even bother to standardize the same keyword in VBA (Datediff), and the arguments also in the wrong order.
It is a formula/command that would be useful for a newbie, yet only be told much later on when it is no longer in need.
Yeah, including chatgpt into excel with valuable company data.... Not going to happen.... 😂