How to split cells in Excel

There are many circumstances where we receive information with multiple data points inside a single cell.  This often occurs when the data’s original intention is slightly different from how we intend to use it.  In these circumstances, we often need to split the cell into its constituent parts.  This post will look at solving this Read More

INFO function in Excel

The INFO function in Excel returns information about the current operating environment.  In total, there are seven pieces of information available: File path of the current folder Number of worksheets in open workbooks Cell reference to the top-left visible cell of the window Operating system version Excel’s calculation mode Excel version Type of operating system Read More

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