Through over 30 years of history, Microsoft Excel has undergone many changes, but one thing remained constant - one formula, one cell. Due to their ability to work with multiple values in a simple manner, without any tricks and quirks, dynamic array formulas are something that every Excel user can understand and enjoy creating. The introduction of dynamic arrays is a long awaited and most welcome change.
If someone says 'This can be done with an array formula', an immediate reaction of many users is 'Oh, isn't there another way?'.
The tutorial explains the concept of new Excel dynamic arrays and shows how they can make your worksheets more efficient and a lot easier to set up.Įxcel array formulas have always been considered a prerogative of gurus and formula experts. Due to the revolutionary update in the Excel 365 calculation engine, array formulas become very straightforward and understandable for everyone, not just for super users.