Linest - different columns for x range
 

For the x_range of Linest try e.g. choose({1,2,3},a1:a100,b1:d:
100,j1:j100).
Or if you have the column numbers listed in say w1,x1,y1 maybe try:

Choose({1,2,3},index(a1:a100,,w1),index(a1:a100,,x 1),index(a1:a100,,y1)

On 23 May, 13:33, SD wrote:
Hi,

I hsve to do heaps of regressions and I have 4 x variables. The x variables
are side by side in the column though so I cant do a function like this
Linest (A1:100,B1:E:100) as w variables are in columns b,c,d the the other is
in column j.

Hence I need to do a calc such as linest(a1:a100,b1:d:100,j1:j100). This
doesnt work though as it doesnt acknowldge the varaibles in column J and
produces an error.

Whats the best way to get around this. I am not in a position to reformat
the spreadsheet and have all the x variables side by side in columns
unfortunately.

Thanks

SD