Automatisation - Operations on a table on one line

[Guest]

Hi,

let's say I have data on A1 to A5 (1;2;3;4;5)

I also have A10=A1

and: B10=2*A10+3 ; C10=B10*3 ; D10=C10+B10 ;

I then transcript the value of D10 in B1.
After, I put A10=A2 and I transcript the value of D10 in B2, etc.

- I could expand A10 toward A14 and the same thing with column B to D.
I could then make cells B1 to B5 equals to D10 to D14 but in my case I
can't because lines 11 and below are took by other things.

-I could write B1=(2*A1+3)*4 but if I change a formula, let's say
C10=exp(A10), I would have to manually compute a new formula for B1.

I know there's a way to do that automaticly, but I don't know how!

Exemple in: http://cjoint.com/?fqrGb3sMgY

Thank you very much,

Alexandre

 

[Guest]

Try a one variable data table.
It's perfect for what your intents here.

Clear A1:B5
List the numbers: 1,2,... 5 in A2:A6 (just shift it down by 1 row)
Then put in B1: =D10
Select A1:B6, click Data > Table

In the Table dialog:
Leave row input cell box blank
Enter in column input cell box: A10
Click OK. That's it !
B2:B6 will return the required results

 

[Guest]

Thank you so much,
it's working very well !

I am obtaining an error if my input cell is in another sheet.
It's not very very important, but if you know if there is a way to correct
this...


Thank you,

Alexandre

 

[Max]

I am obtaining an error if my input cell is in another sheet.

Yes, that's seems to be an operating constraint.
I just live with it <g>