I am trying to perform regressions using the LINEST function and can perform this task if I know the array sizes to use in the formula (ex. =LINEST(A1:A100,B2:D100,,1) ). The sample sizes vary on each run, so one might have 100 sets of data like in the example above, the next might have 200 sets of data (ex. =LINEST(A1:A200,B2:D200,,1) ).
I tried to use a formulas inside the functions (e.g. CONCATENATE) to put in the number of data sets in a particular run, but I get an error every time. Are you able to use other functions inside the LINEST function??
Not trying to do anything fancy here, just trying to pull a different size array without having to re-type the number in the formula each time. I would like to use a formula and avoid VBA scripts if possible.
Thanks for any help.
I tried to use a formulas inside the functions (e.g. CONCATENATE) to put in the number of data sets in a particular run, but I get an error every time. Are you able to use other functions inside the LINEST function??
Not trying to do anything fancy here, just trying to pull a different size array without having to re-type the number in the formula each time. I would like to use a formula and avoid VBA scripts if possible.
Thanks for any help.