| T O P I C R E V I E W |
| HansBrouwer |
Posted - 10/19/2005 : 08:21:18 AM
Hi everyone,
I have 2 worksheets
the first has 1 x and 600 y columns
the second has 1 x and 1 y column.
the x columns are the same for both worksheets.
What i would like to do is divide all 600 y columns by the y column from the second worksheet and to put the results in a new worksheet.
Is there information about this in the tutorial and if not. Can anyone help me out please?
Best regards,
Hans |
| 2 L A T E S T R E P L I E S (Newest First) |
| HansBrouwer |
Posted - 10/19/2005 : 09:57:50 AM
Hi Mike,
Thanks alot!!!
I have already tried it and it is working!
Best wishes,
Hans |
| Mike Buess |
Posted - 10/19/2005 : 09:10:21 AM
Hi Hans,
You will probably need to change the names of the 1st and 2nd worksheets in the first two lines.
%F=Data1; // name of first wks
%S=Data2; // name of second wks
win -a %F; // activate 1st wks
win -d; // duplicate window
doc -e W {%W=%H}; // find name of new wks
win -a %W; // activate new wks
loop (i,2,wks.ncols) {
%(%W,i) /= %(%S,2);
};
Mike Buess
Origin WebRing Member |
|
|
