5 Dynamic Array Gotchas in Excel

/in /by

Dynamic Array Functions in Excel are so fabulous … BUT!

As with anything, there are traps, warnings and caveats. In this video I quickly cover 5 things you should know about Dynamic Array Functions and Formulas.

For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
https://www.linkedin.com/learning/instructors/oz-du-soleil?trk=insiders_28299411_learning
Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2

#DynamicArrays #DynamicArrayWarnings #DynamicArrayFunctions