🚀Get the FREE Data Analytics Guide from Hubspot: clickhubspot.com/1c5
@arnonomdo1341Ай бұрын
I still think the function should be called "DATE-DIF," not "DATED-IF"
@kangjianАй бұрын
I assume Kenji is dating someone. 😂
@mahbubhossain1852Ай бұрын
Agreed! I do call it DATE-DIF 😊
@dakshbhatnagarАй бұрын
I am with you, there is no condition attached to the function, why would someone say dated if 😂
@adityav4939Ай бұрын
'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 😁
@antoniobacic5674Ай бұрын
Beautiful, thank you Kenji. The TAKE + SORT + CHOOSECOLS is very helpful.
@nmarks3 күн бұрын
The AI add-in was fantastic.
@kayespedal1016 күн бұрын
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
@JHatLpool23 күн бұрын
Nice demonstrations of some amazing new features. The capability of Excel is now unbelievable.
@im.nurhadi_Ай бұрын
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!
@KenjiExplainsАй бұрын
Thanks for watching! :)
@xaviergrewalАй бұрын
Kenji, your videos are brilliant! Crisp and absolutely easy to follow👌🏽🙏🏽
@christianwinter20Ай бұрын
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👍
@islammohsen3520Ай бұрын
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 ❤❤
@garybaotutorialАй бұрын
Thank you for this. I am wondering which tools you are using for making this wonderful videos.
@radiali482Ай бұрын
Really your taking us to super levels, than and many thanks
@sallyho146Ай бұрын
Thanks. Can you do a video in comparing 1st and 2nd and what is the easiest:best way to extract difference?
@camlex6310Ай бұрын
Really great tricks!! Thanks!!
@rajsingh2363Ай бұрын
It seems we are not even using 10% of excel functions. Thanks for the info
@JoseAntonioMoratoАй бұрын
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#) 🤗
@radiali482Ай бұрын
correction : "Really you are taking us to super levels, thanks and many thanks"
@sivabvbs2865Ай бұрын
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
@jezzzNLАй бұрын
will all this work in MS Office Home or only for MS 365?
@KenjiExplainsАй бұрын
Hey I'm not too familiar with MS Office Home tbh so I can't comment. I'm currently on MS365
@michaelt312Ай бұрын
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.
@willzinner8813Ай бұрын
do you know if the AI one will become a part of Excel (not an addin) at some point?
@KenjiExplainsАй бұрын
I don't know tbh!
@UKJ28Ай бұрын
Just wow..
@wallywechs4694Ай бұрын
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
@KenjiExplainsАй бұрын
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
@imanuelachawngthu7451Ай бұрын
Handsome kenji
@KenjiExplainsАй бұрын
thank you lol hopefully the video was useful XD
@Dawoodkhan-ry1ssАй бұрын
Sir from where should I download free updated MS Office for long time
@calilthomasАй бұрын
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.
@tejasd198013 күн бұрын
I too don't have the choose cols formula
@jimmyPOUFAJonesАй бұрын
My download and your video file did not match, I had country and units sold columns
@kishanagrawal424322 күн бұрын
My excel not showing new formulas pls help me to get results
@joblesstessАй бұрын
create a regex to help me identify if there are numbers in a list of
@roxipoxi3005Ай бұрын
Datedif was canceled as official formula because, in verry specific conditions, it may give an incorrect result
@eto5609Ай бұрын
What version of Excel are you using? 2021 2024 Microsoft 365 or Office 365?
@obi4830Ай бұрын
Hit the Tab key thereee.
@polyvg4 күн бұрын
DATEDIF is ancient history! Excel > Formulas and functions > More functions > DATEDIF function Warning: Excel provides the DATEDIF function in order to support older workbooks from Lotus 1-2-3. The DATEDIF function may calculate incorrect results under certain scenarios. Please see the known issues section of this article for further details.
@koobzorАй бұрын
Alex Megos 👀
@KenjiExplainsАй бұрын
Hahha glad you noticed XD
@VVeiQuekАй бұрын
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.
@ajitkainchi34928 күн бұрын
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)
@sergheyzaporojanu6872Ай бұрын
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?!
@c.l421911 күн бұрын
Yeah, including chatgpt into excel with valuable company data.... Not going to happen.... 😂
@Agressive324Ай бұрын
4:24 =C3& " " & D3 & "," & E3 & "," & F3 Result will be - Kylee Townsen,56,Pass