The Old and the New
Array formulas have a reputation – and it’s not a particularly good one. For many spreadsheet users, they’re Excel’s equivalent of a dark alley at 3 in the morning; one just doesn’t go there.
Why not? Possibly because array formulas ask the user to think of, and work with, ranges in a way that displaces them from their comfort zone. Every spreadsheet formula works with ranges, of course, but array formulas – both the earlier and the newer dynamic-array kind – subject the values to a different kind of collective treatment. ...
