Chapters:
0:00 - CHOOSECOLS
1:18 - Adding SORT
1:53 - Adding TAKE
2:20 - TEXTSPLIT
3:50 - TEXTJOIN
5:55 - REGEXTEST
6:59 - REGEXEXTRACT
7:50 - GROUPBY
8:56 - PERCENTOF
9:38 - AI.FILL
10:43 - AI.EXTRACT
11:20 - DATEDIF
Find formula with chat gpt
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#
5 New Excel Formulas You Should Know
🚀Get the FREE Data Analytics Guide from Hubspot: https://clickhubspot.com/1c5
🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.co...
No comments:
Post a Comment