#️⃣ Dynamic Arrays in Excel - This Changes Everything!

Dynamic Arrays are a game changer that completely changes how you use formulas in Excel.

Prior to Dynamic Arrays, a formula was used to return one single value, but with Dynamic Arrays, you can return an entire array and spill the results to fill multiple rows and columns in one go.

This has also allowed Excel to introduce many amazing useful functions.

In this video, I will cover everything you need to know about dynamic arrays in Excel and also show you examples of formulas where they can be used.

00:00 Intro
00:28 Introduction to Dynamic Arrays
04:36 Using Dynamic Arrays in a Formula
06:35 Dynamic Array Functions
11:48 Dynamic Array Cautions / Limitations

#Excel #ExcelTips #ExcelTutorial #SumitBansal

[IvanCortinas_ES]

In my opinion, Dynamics arrays have been such a great advance that Excel is still unbeatable today.
Thank you Sumit! Great video.

[dr.rajagopalksrivasavicoll]

A VERY GOOD feature of Excel; very well demonstrated.
Thank you.

[muralikrishnanatarajan]

Excellent demo, very clear, and concise. A valuable additions to my bookmarks!

[claudehsu]

Detailed explanation with useful examples. Good job dude.

[ish]

Wonderful explanation accompanied by great video!
Thank You, Sumit. (Appreciation from Pakistan)

[roberthumphrey]

An extremely useful video. Thanks Sumit - much appreciated.

[RahulGupta-iggv]

This was good working info. on the subject. Thanks 👍

[patrickschardt]

The new dynamic array functions are great

If you need to only access certain rows or columns, use the new TAKE, DROP, CHOOSEROWS, CHOOSECOLS

[vishal_kiyaan]

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 YouTubers are doing this. 

Keep it up.  👍

[mchllwoods]

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.

[ExcelWithChris]

You can also use Chooseclols to only counta the first column of the array.

[akhiljain]

Hi Sumit, will this work in only in MS Excel 365? or will this work in all versions?

[ExcelWithChris]

You can also use the SORT formula with the FILTER in one to sort the filtered data.

[Vivek_Chauhan-ngmo]

Bro i have one request please make a full course on SQL

[RyanJ]

Thank you for your valuable video. My only suggestion would be to speak a little more slowly.

[sandeepkrkrraghav]

Very very useful videos❤❤❤
Please make more videos on this topic Dynamic Arrays

[kokshong]

The moment i put in at cell E2=A2:C12, i got #VALUE! as return. What is wrong ? i am using Excel 2019...

[ShivamMishra-etqm]

I am trying but excel show #VALUE! Error. Using MS pro plus 2013

[MK-jnuu]

Sometimes I wonder how Microsoft is Microsoft.. 😒