Menu
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.
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.
Get FREE Excel & Power-BI Newsletter
One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.
Online Classes
© All rights reserved.
12 Responses to “Dynamic Arrays Live Masterclass – Replay”
What time is it on Friday? where is the button to see the time in my timezone?
9:30 PM IST
Please let me know what time the webinar will start UK time. Thank you.
should be 4 PM GMT (UTC)
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
11 AM EST (US time zone)
should be 11am EST
9.30 PM INDIA??
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.
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.
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
Excellent video!! I learned a ton. Thank you!