E

#### 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