LINEST - how to add no-adjacent columns for the known_x's?

[LIVIA]

I need to know how to selec no-adjacent columns for the known_x's in the linest function:
Example:
'- A B C D E

1) 80 63 9 3 26
2) 80 63 9 3 21
3) 74 65 7 2 30
4) 74 65 7 2 20
5) 63 65 9 3 16

=LINEST(A1:A5,KNOW_X'S,TRUE,TRUE)
Is there any way to select for instance: column B and E as known_x's?

I heard about something where we can select total area and then choose which columns should be considered via "{column1, colum2}"..
That is all is missing for me to finish my project!!! Pls your help!!!

[shg]

Welcome to the forum.

I think you need to make them adjacent.

[LIVIA]

Hi, thank you!
...the thing is that I'm using this Function to do an arranjement of 8 variables, which takes me to 255 combinations. It would be impossible for me to make all of them adjacent...
Any clue on how to make it?!!
PLEASEC!

[shg]

..the thing is that I'm using this Function to do an arranjement of 8 variables, which takes me to 255 combinations.

Why?

It would be impossible for me to make all of them adjacent.

Why?

You could use this:

Please Login or Register  to view this content.

Like this: =LINEST(A1:A5, MakeContig(B1:B5, E1:E5), TRUE, TRUE)

... but it's really an ad-hoc hack.

[LIVIA]

THANK YOU SO MUCH!!!!!!!!!!!!!!
IT REALLY WORKED!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

You have no idea on how long I was looking for it, really!
THANKS, THANKS THANKS!

[shg]

You’re welcome. Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes

[LIVIA]

Sure, but where is the "prefix dropdown"?

[mishen]

Hi,

Could you please tell me how I should modify the macro to be able to use it with my data that is sorted in rows (not columns as above). Thank you very much!

Why?

Why?

You could use this:

Please Login or Register  to view this content.

Like this: =LINEST(A1:A5, MakeContig(B1:B5, E1:E5), TRUE, TRUE)

... but it's really an ad-hoc hack.