Table arrays are particularly useful when working with large sets of data, and they offer auto-filtering features and other tools to make it easy to sort and manipulate data. In conclusion, 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 ...

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

Array languages are awesome. People should be aware of what they're missing out on. This repo offers proof-of-concept implementations of some array programming primitives that are missing from ...

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 ...

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on certain arguments you input. However, combining—or nesting—functions ...

After my recent post on using Office Scripts and cube functions to generate Excel reports from Power BI data, Meagan Longoria asked me this question on Twitter: To which I can only reply: guilty as ...