Shift+Ctrl+Enter

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…