3 ms·
You mean array formula (the {=....} jazz). Matrix functions refer to functions like MINVERSE
by niggler 14y ago
You mean array formula (the {=....} jazz). Matrix functions refer to functions like MINVERSE
- zjonsson 14y agoNot only that, regular algebraic operations also work with vectors/matrices as inputs, as long as you press CTRL-SHIFT-ENTER after editing. This means that most functions with complex MATCH and OFFSET can be replaced as well (i.e. SUM( (column_vector = cvalue) * (row vector = vvalue) * (matrix))