More About Array Formulas
In the previous post, we introduced array formulas. These are formulas you enter into a range of cells using Shift+Ctrl+Enter. That block, or array, works as a unit. You can extend the array easily or, with some difficulty, reduce it. We looked at some array formulas: TRANSPOSE, COLUMN, SUM, and LINEST. If you didn’t read…