It’s been 15 months since Microsoft rocked the calculation boat with its new range of dynamic array functions and features. But what’s actually changed since then? Our Excel MVP Liam Bastick takes a ...

What if you could unlock the full potential of Excel's dynamic arrays within your tables, making your data management more efficient and powerful?

I’ll admit that I’m a bit less excited about Excel dynamic arrays than I was when I last blogged about them. Don’t get me wrong: from a pure Excel point-of-view they are still very cool, but I’ve s… ...

Learn how to use Excel’s dynamic array formulas to automate data pairing, save time, and unlock new insights in your analysis. Excel arrays ...

Prior to the new Dynamic Array functionality, you had to build array formulae if you wanted to work with ranges in Excel. Liam Bastick explains how they both compare.

In the first post in this series I showed how to use the new Excel Lambda helper functions to return an array containing all the items in a set. That isn’t very useful on its own, so in this post I’ll ...

Dynamic Arrays is a tool for Microsoft Excel that allows formulas to be outputted across multiple cells as a list.