🚀Get the FREE Data Analytics Guide from Hubspot: clickhubspot.com/1c5
@antoniobacic5674
Ай бұрын
Beautiful, thank you Kenji. The TAKE + SORT + CHOOSECOLS is very helpful.
@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 😁
@kayespedal10
9 күн бұрын
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
@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👍
@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! :)
@JHatLpool
17 күн бұрын
Nice demonstrations of some amazing new features. The capability of Excel is now unbelievable.
@xaviergrewal
26 күн бұрын
Kenji, your videos are brilliant! Crisp and absolutely easy to follow👌🏽🙏🏽
@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 ❤❤
@rajsingh2363
Ай бұрын
It seems we are not even using 10% of excel functions. Thanks for the info
@radiali482
Ай бұрын
Really your taking us to super levels, than and many thanks
@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#) 🤗
@sallyho146
Ай бұрын
Thanks. Can you do a video in comparing 1st and 2nd and what is the easiest:best way to extract difference?
@garybaotutorial
Ай бұрын
Thank you for this. I am wondering which tools you are using for making this wonderful videos.
@radiali482
Ай бұрын
correction : "Really you are taking us to super levels, thanks and many thanks"
@camlex6310
Ай бұрын
Really great tricks!! 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
@joblesstess
27 күн бұрын
create a regex to help me identify if there are numbers in a list of
@UKJ28
Ай бұрын
Just wow..
@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!
@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
@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.
@imanuelachawngthu7451
Ай бұрын
Handsome kenji
@KenjiExplains
Ай бұрын
thank you lol hopefully the video was useful XD
@kishanagrawal4243
15 күн бұрын
My excel not showing new formulas pls help me to get results
@Dawoodkhan-ry1ss
Ай бұрын
Sir from where should I download free updated MS Office for long time
@jimmyPOUFAJones
Ай бұрын
My download and your video file did not match, I had country and units sold columns
@calilthomas
29 күн бұрын
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.
@tejasd1980
6 күн бұрын
I too don't have the choose cols formula
@eto5609
Ай бұрын
What version of Excel are you using? 2021 2024 Microsoft 365 or Office 365?
@ajitkainchi349
21 күн бұрын
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)
@obi4830
Ай бұрын
Hit the Tab key thereee.
@roxipoxi3005
26 күн бұрын
Datedif was canceled as official formula because, in verry specific conditions, it may give an incorrect result
@koobzor
Ай бұрын
Alex Megos 👀
@KenjiExplains
Ай бұрын
Hahha glad you noticed XD
@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?!
@Agressive324
28 күн бұрын
4:24 =C3& " " & D3 & "," & E3 & "," & F3 Result will be - Kylee Townsen,56,Pass
@VVeiQuek
26 күн бұрын
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.
@c.l4219
5 күн бұрын
Yeah, including chatgpt into excel with valuable company data.... Not going to happen.... 😂
Пікірлер: 51