'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#) 🤗
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.
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
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.
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.
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?!