Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing individual elements of an array returned by a function
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing individual elements of an array returned by a function
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Accessing individual items in an array returned by a function | Excel Programming | |||
elements in an array | Excel Programming | |||
Transpose Function not Working with Long Array Elements | Excel Programming | |||
MS Dialog 5.0 sheets - Accessing data elements of objects | Excel Worksheet Functions | |||
Preformatted array returned by custom function | Excel Programming |