E
exceluser
Is it possible to multiply arrays without summing the results or using
an array entered formula and then determine the largest number in the
resulting array ?
For example, multiply three arrays created from using the INDEX and
OFFSET functions and then LARGE the results.
A B C
1 1 0 1
2 0 0 2
3 1 1 3
The formula should do the following.
$A$1:$A$3 * $B$1:$B$3 * $C$1:$C$3
which should result in an array consisting of {0,0,3}
from which you perform LARGE({0,0,3},1)
which should result in 3.
Exceluser
an array entered formula and then determine the largest number in the
resulting array ?
For example, multiply three arrays created from using the INDEX and
OFFSET functions and then LARGE the results.
A B C
1 1 0 1
2 0 0 2
3 1 1 3
The formula should do the following.
$A$1:$A$3 * $B$1:$B$3 * $C$1:$C$3
which should result in an array consisting of {0,0,3}
from which you perform LARGE({0,0,3},1)
which should result in 3.
Exceluser