True, it opened up the possibility of so many new functions. It's incredible how it has made some of the things so easy that used to take up a lot of time in the past.
I am a new subscriber to this channel. I request that you always share the practice file download link in all videos, where applicable. Take it positively, because many Excel UA-camrs are doing this. Keep it up. 👍
Hi Vishal... I do have a link to the download file in the description of the video. Here is the link again - www.dropbox.com/scl/fi/cok8038j9f7p2oz46kwdl/Dynamic-Arrays.xlsx?rlkey=avlg1hntg3lq203hnvf6bwwk0&dl=1
In my opinion, Dynamics arrays have been such a great advance that Excel is still unbeatable today.
Thank you Sumit! Great video.
True, it opened up the possibility of so many new functions. It's incredible how it has made some of the things so easy that used to take up a lot of time in the past.
I copied your data.
I tried to work on your examples as you did. Towards the end I couldn't duplicate your results.@@trumpexcel
Detailed explanation with useful examples. Good job dude.
A VERY GOOD feature of Excel; very well demonstrated.
Thank you.
Excellent demo, very clear, and concise. A valuable additions to my bookmarks!
Wonderful explanation accompanied by great video!
Thank You, Sumit. (Appreciation from Pakistan)
An extremely useful video. Thanks Sumit - much appreciated.
The new dynamic array functions are great
If you need to only access certain rows or columns, use the new TAKE, DROP, CHOOSEROWS, CHOOSECOLS
Thanks Patrick. Agree, I should have used the Take or Choosecols. That would have been easier
Very Informative .
This was good working info. on the subject. Thanks 👍
Thank you Sumit , very useful
Glad you found the video helpful 🙂
This is brilliant, thank you!
Thanks for updating us
Thank you Sumit!!
I am a new subscriber to this channel.
I request that you always share the practice file download link in all videos, where applicable. Take it positively, because many Excel UA-camrs are doing this.
Keep it up. 👍
Hi Vishal... I do have a link to the download file in the description of the video. Here is the link again - www.dropbox.com/scl/fi/cok8038j9f7p2oz46kwdl/Dynamic-Arrays.xlsx?rlkey=avlg1hntg3lq203hnvf6bwwk0&dl=1
Thanks for the share.
Instead of using COUNTA function to count text, ROWS function is more efficient and you don’t have to use any extra functions or arguments.
Thank you 🙏🏼
You can also use Chooseclols to only counta the first column of the array.
Yeah, that's also a good way to do it. Thanks for the tip 👍
You can also use the SORT formula with the FILTER in one to sort the filtered data.
Yeah, I wanted to highlight that the in-built sort doesn't work with dynamic arrays (as a limitation for people to know)
Hi Sumit, will this work in only in MS Excel 365? or will this work in all versions?
According to Microsoft website, it should work on Excel 2019 and 2021. It also mentions 2016, but some mentioned that it doesn't work on 2016
Thank you so much sumit
Very very useful videos❤❤❤
Please make more videos on this topic Dynamic Arrays
Planning on making more videos on the new Excel functions. That will will also cover dynamic arrays
It’s informative
Bro i have one request please make a full course on SQL
I am trying but excel show #VALUE! Error. Using MS pro plus 2013
It isn't available in 2013. Available in Excel 2016 and above
@@trumpexcel thanks Sir
When was this added to Excel?
This was released in 2018
Is this verison 2019?
According to Microsoft, it should be available in Excel for Microsoft 365, Excel 2021, Excel 2019, and Excel 2016
Thank you for your valuable video. My only suggestion would be to speak a little more slowly.
Thanks Ryan... Will keep this in mind 👍
The moment i put in at cell E2=A2:C12, i got #VALUE! as return. What is wrong ? i am using Excel 2019...
Hindi me bhi video banao
Sometimes I wonder how Microsoft is Microsoft.. 😒