Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've read up on array formulas on the web, and experimented with
multiplying vector array constant with different lengths and orientations. Regardless of the order in which they appear in the expression, if a M-tall array constant is multiplied with a N-wide array constant, the result is an M-tall, N-wide matrix. The result at the mth row and nth column is the product of the mth element from the tall vector and the nth element from the wide vector. How universal is this? Can this be relied upon to hold in all situations? I got the vertical vectors using TRANSPOSE(). Things get complicated if I multiply 2-D array constants of differing dimensions. Does anyone know the rules for this? Does it actually do anything useful enough to be exploited? Finally, I noticed that one can specify a target area for the array multiplication that differs in size from the resulting matrix. If it is too small along a certain dimension, the matrix simply gets truncated along that direction. If it is too big, the extra cells are filled with #N/A. Is there a way to show the boundary of cells over which an array formula is specified? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Looping through each element of an array | Excel Programming | |||
Permutations of an array element < to a value | Excel Worksheet Functions | |||
Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
Array element | Excel Programming |