Menu

Accessing individual elements of an array returned by a function

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.programming

Alan Beban[_2_] Alan Beban[_2_] is offline

Alan Beban[_2_] is offline

external usenet poster

Posts: 783

Default

Accessing individual elements of an array returned by a function

wrote:
If I call an Excel function (e.g. Linest) that returns an array (in
the case of Linest, the slope and the intercept), how can I access one
particular element of the array that is returned?

If I select two cells, type =Linest(a1:a10,b1:b10) in one and then hit
Ctl-Shift-Enter to enter an array formula, both the slope and the
intercept are returned, one in each cell. But what if I want just the
slope or just the intercept? I tried entering =Linest(a1:a10,b1:b10)
(1) in a single cell but got only an error. What am I doing wrong? I'm
aware that in this particular case, I could use the Slope() and
Intercept() functions separately to get what I want, but there has to
be a general solution for any function that returns an array.

Sincerely

Thomas Philips
If the two cells you selected are in one column, you might try

=INDEX(Linest(A1:A10,B1:B10),1,1) for the slope,

=INDEX(Linest(A1:A10,B1:B10),2,1) for the intercept.

If the two selected cells were in one row, try

=INDEX(Linest(A1:A10,B1:B10),1,1) for the slope,

=INDEX(Linest(A1:A10,B1:B10),1,2) for the intercept.

Alan Beban

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Accessing individual items in an array returned by a function	[email protected]	Excel Programming	2	December 4th 07 04:01 PM
elements in an array	Chip Pearson	Excel Programming	2	November 23rd 07 12:19 PM
Transpose Function not Working with Long Array Elements	Ngan	Excel Programming	1	August 9th 05 08:59 PM
MS Dialog 5.0 sheets - Accessing data elements of objects	Malriem	Excel Worksheet Functions	2	June 4th 05 04:46 PM
Preformatted array returned by custom function	Asif[_3_]	Excel Programming	9	December 4th 03 06:31 AM

All times are GMT +1. The time now is 12:02 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement