TEXTSPLIT is my second killer, essentially parsing a string by delimiter - so replicating the data parsing menu options in a function. Fantastic. Kudos to Sele, but Excel devs are the real MVP!!
Hi, good job! I ould like to know, is thee a way to exract with the take function some rows from the middle or just another row other starting row from beginning/end
Great tutorial to get a quick and concise overview of array functions.
Amazing as always
TEXTSPLIT is my second killer, essentially parsing a string by delimiter - so replicating the data parsing menu options in a function. Fantastic.
Kudos to Sele, but Excel devs are the real MVP!!
your videos are always informative👏👏
Awesome information
Useful functions. And you explained them very clearly. Well done 👍
Very nice video 📹 👍 Thank you for sharing your knowledge
Hi, good job! I ould like to know, is thee a way to exract with the take function some rows from the middle or just another row other starting row from beginning/end
Will these functions replace the Excel Power Query function when working with CSV type files? Excellent video, thanks!
I love this
Thanks
Just posted on my LinkedIn =)
The text functions are literally the only useful ones in this video. The others seems almost useless unless your data is straight up crazy.
So Sele, 1 video every 3 months?
It has been slow. Stay tuned!
pretty useless formulas tbh but thx for video
Exactly, the useful ones stay the same or else everyone will face problems. The AI addons are useful though.