LINEST with TRANSPOSE

[mike hutchins]

I've entered the following across 3 cells as an array formula:
=LINEST(TRANSPOSE(FirstRow),TRANSPOSE(SecondRow)^{1,2})
so that curly brackets {} surround it.

The named ranges "FirstRow" and "SecondRow" are two single rows of
data across 20 columns. I'd assumed that including TRANSPOSE would
address the LINEST requirement for the arrays to be in columns but it
seems not, or I'm doing something wrong because the resulting matrix
is "#VALUE!"

Can anyone help?
Cheers.....Mike

 

[Harlan Grove]

I've entered the following across 3 cells as an array formula:
=LINEST(TRANSPOSE(FirstRow),TRANSPOSE(SecondRow)^{1,2})
so that curly brackets {} surround it.

The named ranges "FirstRow" and "SecondRow" are two single rows of
data across 20 columns. I'd assumed that including TRANSPOSE would
address the LINEST requirement for the arrays to be in columns but it
seems not, or I'm doing something wrong because the resulting matrix
is "#VALUE!"

LINEST's first two arguments do not need to be arranged in columns. LINEST uses
the shape of its first argument (Y) to determine how to interpret its second
argunment (X). The TRANSPOSE calls are unnecessary, but if you eliminate them,
your array of exponents would need to change to {1;2}.

Are you selecting a 1-row by 3-column range, entering the LINEST formula, then
holding down [Ctrl] and [Shift] keys before pressing [Enter] in order to make
the formula an array formula?