#️⃣

Подписаться 368 тыс.

Просмотров 10 тыс.

50% 1

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.
Download Example File - www.dropbox.com/scl/fi/cok803...
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
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: ru-vid.com...
#Excel #ExcelTips #ExcelTutorial #SumitBansal

Опубликовано:

11 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 43

@IvanCortinas_ES 2 месяца назад

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

@trumpexcel 2 месяца назад

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.

@bobgreenfield9158 20 дней назад

I copied your data. I tried to work on your examples as you did. Towards the end I couldn't duplicate your results.@@trumpexcel

@claudehsu9869 24 дня назад

Detailed explanation with useful examples. Good job dude.

@dr.rajagopalksrivasavicoll3642 2 месяца назад

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

@ish011 2 месяца назад

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

@WekomVideos 2 месяца назад

This is brilliant, thank you!

@patrickschardt7724 2 месяца назад

The new dynamic array functions are great If you need to only access certain rows or columns, use the new TAKE, DROP, CHOOSEROWS, CHOOSECOLS

@trumpexcel 2 месяца назад

Thanks Patrick. Agree, I should have used the Take or Choosecols. That would have been easier

@roberthumphrey8283 2 месяца назад

An extremely useful video. Thanks Sumit - much appreciated.

@muralikrishnanatarajan6229 2 месяца назад

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

@SyedMuzammilMahasanShahi 2 месяца назад

Thanks for the share.

@abhishekpandey21790 2 месяца назад

Thanks for updating us

@jhankhanajani9314 2 месяца назад

Thank you Sumit!!

@Satwant2463 2 месяца назад

Thank you 🙏🏼

@juliepena 2 месяца назад

Thank you Sumit , very useful

@trumpexcel 2 месяца назад

Glad you found the video helpful 🙂

@mchllwoods 2 месяца назад

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.

@benjaminvictor1051 2 месяца назад

Thank you so much sumit

@CAKPRashique 2 месяца назад

It’s informative

@vishal_kiyaan 2 месяца назад

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 RU-vidrs are doing this. Keep it up. 👍

@trumpexcel 2 месяца назад

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