Advanced dynamic array formula techniques

In the final part of this dynamic array series, we’ll look at a few advanced formula techniques.  We won’t be covering the individual functions in detail but considering how we can combine them to solve some tricky problems.  Many of these techniques have been covered briefly as examples in previous posts, but now we’ll dig Read More

Using dynamic arrays with other Excel features

So far, in this series, we’ve looked at how dynamic arrays work and the new functions that are available to us.  Most of our examples have focused on calculations that occur on the worksheet.  But we’ve not yet considered how dynamic arrays work with other Excel features, such as charts, data validation, conditional formatting, etc.  Read More

Dynamic arrays and VBA user defined functions (UDFs)

Office 365 subscribers now have Excel’s new calculation engine available to them, meaning lots of users suddenly have access to dynamic arrays.  This got me thinking about whether VBA user-defined functions (UDFs) can make use of the new functionality too. I’m not an expert in this; I’m just sharing as much as I’ve learned to Read More