Dynamic Array Formulas in Excel - 8 Things You Need to Know

In this video, we explore dynamic array formulas in Excel and 8 things you need to know about using them.

If you are just starting to write array formulas using the new formula engine of Excel, then some nuances may take you by surprise.

This video will show you the best approach to writing them, and avoid pitfalls in their application. It will also show how they can be used with other Excel features and compatibility with other Excel versions.

The dynamic array formulas in Excel change the way formulas are written. No more copying formulas down rows, or editing sources of features such as charts and Data Validation.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[sachinrv]

This is a next level Excel. Among all the developments in Excel over last two decades, Dynamic Array is probably the BEST. It is user friendly and very easy to follow. Also no need for C+S+E keys, no need to remember ARRAY complexity or tricky functions like SUMPRODUCT. Simply wonderful. Thanks for sharing :):):)

[roberth.]

Thank you for this nicely presented comprehensive overview of the new array functions. Helped me greatly!

[jacobpos]

Thank you!!! Exactly what I've been looking for. Thank you thank you!!

[wayneedmondson]

Hi Alan.. awesome video.. and thanks for putting this out even during these wild and uncertain times in the world. If nothing else, we can all use our sequestered / quarantined time to get better at Excel. As always, thanks to you and Computergaga for helping us advance our skills. Thumbs up and stay safe out there!!

[hazemali]

my Lovely favorite channel Computer Gaga🥇

[mohideenthassim]

As usual a superb explanation Alan, many thanks and stay safe
Cheers
Mohideen

[emilythechef]

I've been using Excel at a pretty advanced level (and before that, Lotus 1-2-3) for close to 30 years. My.Mind.Is.Blown. I've utilized Array formulas but not understood them... just found a formula to satisfy a need here and there. I'm SO excited to become an Array user. I'll have to watch this video 3 or 4 times, but more ad revenue for you :D THANK YOU for sharing your expertise!

[darrylmorgan]

Excellent Tutorial.. Really Helpful To Understanding Array Formulas!Thank You Alan :)

[financialanalyst]

Thanks a lot sir,
I have a problem when i use Dynamic array. im getting an error 'Value' error, even if i use {} or ctrl + shift enter.

[hespinobc]

My Excel 365 does not seem to have these functions available yet. Will they become available as soon as my office is updated or some configuration changes are are needed? please advise. Thanks

[sasavienne]

First Like. I will start watching now. Thanks Alan. Salim

[viis]

I'm using office 2019 but these seem now to work on my excel, I had to select C2:C13 and ctrl+shift+enter for it to work. Do I need to configure my excel?

[jazchopra]

Hello Good noon Sir,
in my Ms.office excel -2010 these dynamic functions are not working properly. how can I use these tricks please help.

[XMegaJuni]

Im here after i tried to add two columns in a filter array O_O. Can i add values in an array?

[ahmedJaber]

excel doesn't seem to recognise "filter and unique" formulas?

[lisamccray]

I don't understand when to use the absolute reference as opposed to not using it. I kinda know technically how to use it. Just when to use it confuses me.