Excel also has array formulas that have the syntax like this: {=(A1:A10_B1:B10)}, and the same formula appears in a range of cells, rather than a copy of the formula with updated references. In reality this formula is the same as having written =A1_B1, =A2_B2, =A3_B3, ..., =A10*B10. We may want to address this at some point.
Excel also has array formulas that have the syntax like this: {=(A1:A10_B1:B10)}, and the same formula appears in a range of cells, rather than a copy of the formula with updated references. In reality this formula is the same as having written =A1_B1, =A2_B2, =A3_B3, ..., =A10*B10. We may want to address this at some point.