Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Accessing individual elements of an array returned by a function
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Alan Beban, post: 6306086"] 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 [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Accessing individual elements of an array returned by a function
Top
