Introduction
Excel array formulae are not straightforward. In some ways they can be as complex and difficult as most Excel users would like to get. Often there are simpler and easier alternatives to using array formulae, but sometimes arrays are either unavoidable or the least bad option. In the last few weeks of doing Excel lectures, I’ve been set three separate challenges for which an array formula is a possible solution.
Let’s try and ex...