What I took from this is the unique function. Genious. Cheers.
@TeachExcel3 жыл бұрын
I'm glad I could help :) It makes me think that I should flesh-out that example a bit more as it really does make life so much nicer now.
@jackcurl2005 Жыл бұрын
@@TeachExcel And combining UNIQUE and SORT in one statement is pretty helpful, too. MS is moving more and more database functionality (the "what I want" vs "how do I get what I want", or declarative vs procedural) into Excel. Abstraction is a good thing. Now, if Microsoft could incorporate Power Query into Access and make its interface less klunky (stop reformatting my SQL into an unreadable mess!), that would be killer. One can dream.
@TeachExcel3 жыл бұрын
This is a beta function for Excel 365 I found yesterday and thought it was interesting. Let me know if you have any other uses for it :)
@darrylmorgan3 жыл бұрын
Cool Tutorial,I Have Never Used ARRAYTOTEXT() So Just Learned A New Fuction...Thank You Sir :)
@TeachExcel3 жыл бұрын
I'm glad I could show you something new Darryl :)
@Fxingenieria3 ай бұрын
Excellent !!!
@IvanCortinas_ES3 жыл бұрын
Excellent tutorial. How long has it been in operation? Thank you!
@TeachExcel3 жыл бұрын
Thank you! You're very welcome Ivan :) You know, this is funny because I did some digging and it seems to have been released last year, or maybe earlier, for some people, and it seems like they had bigger plans for it relating to newer data types, but maybe they just put that stuff on the back-burner but left this guy in there. I found the function by accident this week.
@IvanCortinas_ES3 жыл бұрын
@@TeachExcel I did not know about this function. A lot of LET, a lot of LAMBDA and then you come across this feature! My face was like I had landed on planet Earth.
@AaronHernandez-xv4qh3 жыл бұрын
This is great stuff!
@TeachExcel3 жыл бұрын
Thanks! I'm glad you think so Aaron :)
@AaronHernandez-xv4qh3 жыл бұрын
@@TeachExcel any guesstimate on when the macro/vba course will be complete? Waiting patiently, excited for that to come out.
@TeachExcel3 жыл бұрын
I really appreciate that Aaron! I have learned to not make another prediction, but I have finished all of the big stuff, and now am in a video editing phase and adding intros to every section. There is a chaaaaance that I made the course a little comprehensive, but I must say that I am very happy with it and I think once someone takes it, they will feel comfortable tackling any task in vba. Once again, I am very sorry that I have not been able to meet my deadlines for publishing it!!!
@cazmaj2 жыл бұрын
Thanks, great tutorial. Subscribed and will have a look through some of your other vids :)
@rafeehelmy44052 жыл бұрын
This video is amazing , thank u
@wayneedmondson10653 жыл бұрын
Interesting! Thanks for sharing this :)) Thumbs up!!
@kolavithonduraski50313 жыл бұрын
you could use it in VBA maybe... maybe to convert data to collections (unique keys) or arrays. with worksheetfunction.unique() or worksteetfunction.arrayToText() especially when it is data you just need in one cell, separated with comma or semicolon. 👍 Thanks.
@TeachExcel3 жыл бұрын
Definitely liking your thoughts on using it in VBA! I also think Excel was or is planning to use it for something else that is not yet fully implemented.
@micheltremblay81843 жыл бұрын
Thank you very much, your videos are very informative for me and you have a calm voice. But you keep moving your mouse in circles and it makes me dizzy, :) Have a nice day
@TeachExcel3 жыл бұрын
Oh I'm sorry about that! I actually thought that would make the videos better for people - I will try to be less spastic with my movements.
@vikaasb20163 жыл бұрын
Awesome
@TeachExcel3 жыл бұрын
Thanks Vikus! :)
@Rio_Rioz3 жыл бұрын
Great! Только как часто и где на практике необходимо заменять массивы на текст в строчку..?
@TeachExcel3 жыл бұрын
English is easier for me, but I think i got it lol - I'm not sure how useful this function will be going forward compared to textjoin, it depends what they do with it. But combining a range into a single cell for output is quite useful as a future tutorial will show you regarding outputting slicer selections in a single cell.
@erikguzik82042 жыл бұрын
"Excel"lent..!!! just a quick note, when you want the column in a table i.e. Table[Mrf]. hover just above the column header and you will see a thick black down arrow. Click and you will insert the table column into your formula. Makes it much easer when you have 1000's of rows of data.
@micheltw3 жыл бұрын
How did you find that beta function?
@TeachExcel3 жыл бұрын
I was just messing around with arrays and looking for functions that might be new to slice and dice them like you can do in vba and found this guy and investigated what it was. I not sure they are even planning to keep this in there as almost no mention of it is made online beyond a very basic usage.
@abbottkatz88302 жыл бұрын
Couldn't you also write =ARRAYTOTEXT(H23#)?
@gamestertrader30473 жыл бұрын
Hi stamble to your video tutorial Im looking for a formula and how to set up to the output. I want Letter separated per cell Pattern 1: LWLWLWLWL Pattern 2: LLWLLWLLW Patter 3: WWWLWWWLW Patter 4: LLLLLLLLL Pattern 5: WWWWWWWWW Results LLWLWWWWWLWWLLLLWWLWLWL--- What I want is to predict the possible letter that will come out next base on the establish pattern. i hope you can give me a guide
@arijitpaul27512 жыл бұрын
cost for workshop
@paulhetherington3854 Жыл бұрын
1= the whole - system! 2= tiny ()-call - you have - zero array.