Results 1 to 2 of 2

Thread: Need help in excel

  1. May 5th, 2006, 06:12 AM #1
    csKanna
    csKanna is offline

    Thread Starter
    Hyperactive Member csKanna's Avatar
    Join Date
    Dec 2005
    Location
    Tech-Tips-Now.com
    Posts
    339

    Need help in excel

    I'm try to run a multiple regression using LINEST. However, my two independent variables are located in different worksheets. Is there a way to run LINEST anyways, or do I have to move them together?

    My question deals specifically with having multiple independent variables located at different worksheets. So, the formula would be =LINEST(A1:A2,B1:C2). Now imagine that we keep column B where it is, but move column C to a different worksheet. Is there a way to still use LINEST? Moreover, this question relates to all array formulas in general, not only LINEST.

    Thank you
    Reply With Quote Reply With Quote
  2. May 5th, 2006, 03:29 PM #2
    VBAhack
    VBAhack is offline
    Fanatic Member VBAhack's Avatar
    Join Date
    Dec 2004
    Location
    Sector 000
    Posts
    617

    Re: Need help in excel

    Sure. Excel functions can reference other workbooks:

    LINEST(F5:F8,'C:\$user\Excel\[junk2.xls]Sheet1'!$A$1:$A$4)

    The other workbook can be open or closed.
    VBAhack
    (Links: Cubic Spline Tutorial, Parametric Cubic Spline Tutorial, VB Numerical Routines    )

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width