Watch the Replay & Get files

Dynamic Array Functions in Excel

Thanks for attending this live event. If you want to watch the reply or missed the session, watch it from above (or on YouTube here).

In the video, I covered:

Why you should care about Excel DA functions?
The incredible # operator
6 new functions in Excel - FILTER, SORT, SORTBY, UNIQUE, SEQUENCE & RANDARRAY
25+ real world examples of DA formulas
Your questions answered

Example Data & Completed Workbook

Please download the files from this session using below links.

👉 Sample data

💥 Complete file with all examples

Additional resources to learn Dynamic Array functions

Use below links & course to learn DA functions in Excel

👉 Dynamic Array formulas in Excel – Complete guide

💻 Excel School online training program by Chandoo

Got a question? Leave it here.

12 Responses to “Dynamic Arrays Live Masterclass – Replay”

Kunal Jain says:

February 23, 2021 at 8:19 am

What time is it on Friday? where is the button to see the time in my timezone?

Reply
- Will says:
  
  February 24, 2021 at 6:44 am
  
  9:30 PM IST
  
  Reply
Pat says:

February 23, 2021 at 6:14 pm

Please let me know what time the webinar will start UK time. Thank you.

Reply
- Will says:
  
  February 24, 2021 at 6:43 am
  
  should be 4 PM GMT (UTC)
  
  Reply
Stephen POWELL says:

February 23, 2021 at 11:54 pm

Hello Chandoo,

Please help me understand if the 11:00 (AM?) YouTube session on Friday is your local time in New Zealand or is it 11:00 AM in another time zone? If it's your local time then that would make it 18 hours earlier at 5pm on Thursday Toronto time for me (which works nicely!!).

Thanks,
Stephen

Reply
- Will says:
  
  February 24, 2021 at 6:44 am
  
  11 AM EST (US time zone)
  
  Reply
Will says:

February 24, 2021 at 6:42 am

should be 11am EST

Reply
VIKAS JAIN says:

February 26, 2021 at 11:13 am

9.30 PM INDIA??

Reply
Curt says:

March 3, 2021 at 10:31 pm

I noticed 'Currency' as one of the Data Types. Can you tell me how to add that? I only have Stocks & Geo and currency is more useful for me. I checked the excel website and they didn't present currency as an option.

Reply
Warren Hall says:

March 4, 2021 at 1:30 am

A simple way to manage headers and formatting for the new extraction page is; copy the headers to the second page on row one, column B, then, copy the data line two on the data page, mark the COLUMNS from start to end of the header on the extraction page, then paste-format which will correct all columns to the desired format. Very fast and easy.

Reply
Phil Forman says:

March 4, 2021 at 10:54 am

Have just watched the recorded session, thanks Purna for a very clear rundown on dynamic arrays, I can see lots of users for the knowledge

Reply
Victoria Rice says:

March 26, 2021 at 7:21 pm

Excellent video!! I learned a ton. Thank you!

Reply