Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatisation - Operations on a table on one line
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatisation - Operations on a table on one line
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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Alexandre Campeau" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatisation - Operations on a table on one line
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" wrote: 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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Alexandre Campeau" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatisation - Operations on a table on one line
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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Alexandre Campeau" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting line on line chart to display after creation from Pivot Table | Charts and Charting in Excel | |||
how to concatenate operations | Excel Worksheet Functions | |||
OWC operations in Excel | Excel Discussion (Misc queries) | |||
operations on arrays | Excel Worksheet Functions | |||
Repeating VBA operations | Excel Discussion (Misc queries) |