The following data is imputted:

A B

1 20234
2 21003
3 10000


Some worksheet functions return arrays of values, or require an array of
values as an argument. To calculate multiple results with an array formula,
you must enter the array into a range of cells that has the same number of
rows and columns as the array arguments have.

Select the range of cells in which you want to enter the array formula.
Type the array formula.
For example, given a series of three sales figures (column B) for a series
of three months (column A), the TREND function determines the straight-line
values for the sales figures. To display all of the results of the formula,
it is entered into three cells in column C (C1:C3).



Array formula that produces multiple results

When you enter the formula =TREND(B1:B3,A1:A3) as an array formula, it
produces three separate results (22196, 17079, and 11962), based on the three
sales figures and the three months.

Press CTRL+SHIFT+ENTER.

QUESTION: PLEASE EXPLAIN WHERE THE 17079 and 11962 come from in the above
example.

I do NOT understandm the 3 separate results??

Thanks,

FLKulchar

Hi,

Make sure you're using absolute range address like :
=TREND($B$1:$B$3,$A$1:$A$3)

in every C1:C3 cell
--

Regards,

Halim


"F. Lawrence Kulchar" wrote:

The following data is imputted:

A B

1 20234
2 21003
3 10000


Some worksheet functions return arrays of values, or require an array of
values as an argument. To calculate multiple results with an array formula,
you must enter the array into a range of cells that has the same number of
rows and columns as the array arguments have.

Select the range of cells in which you want to enter the array formula.
Type the array formula.
For example, given a series of three sales figures (column B) for a series
of three months (column A), the TREND function determines the straight-line
values for the sales figures. To display all of the results of the formula,
it is entered into three cells in column C (C1:C3).



Array formula that produces multiple results

When you enter the formula =TREND(B1:B3,A1:A3) as an array formula, it
produces three separate results (22196, 17079, and 11962), based on the three
sales figures and the three months.

Press CTRL+SHIFT+ENTER.

QUESTION: PLEASE EXPLAIN WHERE THE 17079 and 11962 come from in the above
example.

I do NOT understandm the 3 separate results??

Thanks,

FLKulchar

Select cells c1:c3 and enter the formula in the formula bar, then
Ctrl-Shift-Enter


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"F. Lawrence Kulchar" wrote in
message ...
The following data is imputted:

A B

1 20234
2 21003
3 10000


Some worksheet functions return arrays of values, or require an array of
values as an argument. To calculate multiple results with an array
formula,
you must enter the array into a range of cells that has the same number of
rows and columns as the array arguments have.

Select the range of cells in which you want to enter the array formula.
Type the array formula.
For example, given a series of three sales figures (column B) for a series
of three months (column A), the TREND function determines the
straight-line
values for the sales figures. To display all of the results of the
formula,
it is entered into three cells in column C (C1:C3).



Array formula that produces multiple results

When you enter the formula =TREND(B1:B3,A1:A3) as an array formula, it
produces three separate results (22196, 17079, and 11962), based on the
three
sales figures and the three months.

Press CTRL+SHIFT+ENTER.

QUESTION: PLEASE EXPLAIN WHERE THE 17079 and 11962 come from in the above
example.

I do NOT understandm the 3 separate results??

Thanks,

FLKulchar

I did all of that...and I got the SAME 3 values.....22196;

I do NOT YET understand where (or how) the 3 values come from??

Please advise.

FLKulchar

"Halim" wrote:

Hi,

Make sure you're using absolute range address like :
=TREND($B$1:$B$3,$A$1:$A$3)

in every C1:C3 cell
--

Regards,

Halim


"F. Lawrence Kulchar" wrote:

The following data is imputted:

A B

1 20234
2 21003
3 10000


Some worksheet functions return arrays of values, or require an array of
values as an argument. To calculate multiple results with an array formula,
you must enter the array into a range of cells that has the same number of
rows and columns as the array arguments have.

Select the range of cells in which you want to enter the array formula.
Type the array formula.
For example, given a series of three sales figures (column B) for a series
of three months (column A), the TREND function determines the straight-line
values for the sales figures. To display all of the results of the formula,
it is entered into three cells in column C (C1:C3).



Array formula that produces multiple results

When you enter the formula =TREND(B1:B3,A1:A3) as an array formula, it
produces three separate results (22196, 17079, and 11962), based on the three
sales figures and the three months.

Press CTRL+SHIFT+ENTER.

QUESTION: PLEASE EXPLAIN WHERE THE 17079 and 11962 come from in the above
example.

I do NOT understandm the 3 separate results??

Thanks,

FLKulchar

check my response

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"F. Lawrence Kulchar" wrote in
message ...
I did all of that...and I got the SAME 3 values.....22196;

I do NOT YET understand where (or how) the 3 values come from??

Please advise.

FLKulchar

"Halim" wrote:

Hi,

Make sure you're using absolute range address like :
=TREND($B$1:$B$3,$A$1:$A$3)

in every C1:C3 cell
--

Regards,

Halim


"F. Lawrence Kulchar" wrote:

The following data is imputted:

A B

1 20234
2 21003
3 10000


Some worksheet functions return arrays of values, or require an array
of
values as an argument. To calculate multiple results with an array
formula,
you must enter the array into a range of cells that has the same
number of
rows and columns as the array arguments have.

Select the range of cells in which you want to enter the array
formula.
Type the array formula.
For example, given a series of three sales figures (column B) for a
series
of three months (column A), the TREND function determines the
straight-line
values for the sales figures. To display all of the results of the
formula,
it is entered into three cells in column C (C1:C3).



Array formula that produces multiple results

When you enter the formula =TREND(B1:B3,A1:A3) as an array formula, it
produces three separate results (22196, 17079, and 11962), based on
the three
sales figures and the three months.

Press CTRL+SHIFT+ENTER.

QUESTION: PLEASE EXPLAIN WHERE THE 17079 and 11962 come from in the
above
example.

I do NOT understandm the 3 separate results??

Thanks,

FLKulchar