Everyone on the Beta channel seems to be lucky but me :-( Can’t wait to play and work with these new functions as soon as I get them. BTW: I wish TOCOL would default to column-wise instead of row-wise, in order to be as intuitive as possible.
@AccessAnalytic
2 жыл бұрын
Even half the MVPs don’t have it, it’s just a lottery for all!
@AccessAnalytic
2 жыл бұрын
Apparently now available to 100% of beta
@joelgoom3202
2 жыл бұрын
Great video Wyn
@AccessAnalytic
2 жыл бұрын
Thanks Joel
@mohammedelsakally540
2 жыл бұрын
Thank you very much ,, i watched many channels for these new formula but i understaned it from you because your language is so simple and you are go to the traget directly ... so continue and we are supporting you ...
@AccessAnalytic
2 жыл бұрын
Thank you, I greatly appreciate your kind comments Mohammed
@Sasha_5M
2 жыл бұрын
These formulas are not reflecting in my excel 365... could you please help how we can get these formulas?
@AccessAnalytic
2 жыл бұрын
Hi Sanju, I state the requirements at the beginning of the video. What version of Excel do you have?
@Sasha_5M
2 жыл бұрын
@@AccessAnalytic I am using Office 365 Version 2204 (Build 15109.20000) and also have joined office insider program beta channel....but still i am not able to see these formulas in it....could you please help ?
@AccessAnalytic
2 жыл бұрын
Hi Sanju, as I mention at the start of the video only 50% or so of people on insiders have it. It’s slowly being released to the other 50% over coming weeks
@Sasha_5M
2 жыл бұрын
@@AccessAnalytic Thanks a lot sir....Namaste 😊🙏
@AccessAnalytic
2 жыл бұрын
Should be available to 100% on insider now
@patrickschardt7724
2 жыл бұрын
I was just looking to see if anyone did a sim plied version of the sheet name formula. Great example. No one else has done a TEXTAFTER formula for it yet. There’s plenty with MID, RIGHT, etc I just thought of SHEETINFO(Reference, Info_Type) It returns either the full file path, file name, or sheet name, given a reference and the info to return Reference: cell, range, or table reference; if omitted it will use the current cell Info_Type: 0 or omitted=sheet name, 1=file name, 2=file path
@AccessAnalytic
2 жыл бұрын
Good stuff Patrick
@wayneedmondson1065
2 жыл бұрын
Awesome Wyn! Thanks for the demo. Looking forward to playing with these when released. Thumbs up!!
@AccessAnalytic
2 жыл бұрын
Cheers Wayne
@MrWish332
2 жыл бұрын
This is really very cool functions.
@AccessAnalytic
2 жыл бұрын
Totally Vishal
@gogoldgoal
2 жыл бұрын
Finally, split, array append arrived.
@AccessAnalytic
2 жыл бұрын
Excellent!
@w13ken
2 жыл бұрын
Excellent walkthrough Wyn, many thanks. Just when you think you're pretty good you realise you still have a lot to learn!
@AccessAnalytic
2 жыл бұрын
The more you learn the more you discover there is to learn
@gvinodnair
2 жыл бұрын
These bunch of new functions will surely pave the way for getting rid of some ridiculous and complex way of addressing some real-life worksheet problems. Excel is evolving at an increased pace these days and targeting the "SKY IS THE LIMIT" which is good news for all the Excel lovers out there. And Wyn as usual clever way of presenting it to your audience.
@AccessAnalytic
2 жыл бұрын
Thanks Vinod, it keeps getting better!
@IvanCortinas_ES
2 жыл бұрын
I have seen you delighted with the new formulas. It is certainly a breakthrough in every way. I hope they release them soon in classic 365. Thanks Wyn!!
@AccessAnalytic
2 жыл бұрын
Hurry…!
@jorstube
2 жыл бұрын
Super Cool Wyn, Thank you....these new features will save many steps in some uses of excel
@AccessAnalytic
2 жыл бұрын
Absolutely Jorge. Thanks for taking the time to leave a kind comment
@OzduSoleilDATA
2 жыл бұрын
Simply amazing! WOW!
@AccessAnalytic
2 жыл бұрын
Opens up a lot of options for folks to get really creative
@JonathanExcels
2 жыл бұрын
This should make it easier when you need to perform an xmatch or xlookup across separate tables because you can stack the data sources.
@AccessAnalytic
2 жыл бұрын
Yep, great use case Jonathan
@LotfyKozman
2 жыл бұрын
Very smart functions. Thanks
@AccessAnalytic
2 жыл бұрын
You’re welcome Lotfy
@gvinodnair
2 жыл бұрын
@Wyn, any clue how to separate individual characters in the words to different columns? Which technique/ formula can be used?
@AccessAnalytic
2 жыл бұрын
Hi Vinod, combination of MID and SEQUENCE check this out kzitem.info/news/bejne/ooGv2HuAcnWmjKA
@gvinodnair
2 жыл бұрын
@@AccessAnalytic Thanks! Sure, I will try that. Scenario: Customer service would like to hear the email ID so legibly i.e. in phonetic alphabet (A-Alpha, B-Bravo etc...) way so that they can follow it easily and capture it more efficiently. Splitting the characters will help us do this task more easily.
@gvinodnair
2 жыл бұрын
Yay! Thanks again, I followed your tips and solved it ✌✌✌✌ Formula which I used; =MID(D10,SEQUENCE(1,LEN(D10),1),1)
Пікірлер: 44