This session demonstrates the new dynamic array functionality provided in Excel 365, and why we don't need to use SUMPRODUCT for totalling conditionally or when working with arrays of weighting factors. Some old array techniques that lived on a dusty shelf are dusted off and put to powerful use in new calculations, not previously possible in Excel.
It presents key information to understand when dynamic arrays are triggered, what functions do and what functions don't work in dynamic arrays, the functions that work, but not as desired and the workarounds. The impact of using dynamic arrays on recalculation times is discussed and where to draw the line on complexity.
Participants should be familiar with Excel and comfortable working with formulas and functions such as IF, INDEX, MATCH, LOOKUP or VLOOKUP or or XLOOKUP, and SUMPRODUCT.