Dynamic Arrays: SORT, FILTER, and Dynamic VLOOKUP

/in /by

7 new Dynamic Array functions have been added to Excel! In this video you’ll see the FILTER and SORT functions and how 4 formulas bring back results in lots of cells!

Also:
– There’s new nomenclature using the # to reference a dynamic range.
– The new SPILL error lets you know that your result doesn’t have enough room. So, you need to move something and make room.

#DynamicArrays
#DynamicArrayFormulas
#DynamicVLOOKUP

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