Now that we have worked through several examples with the syntax of arrays and have seen how arrays can make spreadsheets easier, this article goes even further. The most important thing to remember as you follow the examples in this article is to enter the formulas with Ctrl+Shift+Enter to get the curly braces that surround Excel formulas.
The full content of this article is only available to HBMA members.