| T O P I C R E V I E W |
| elena_loginova |
Posted - 10/06/2009 : 9:56:25 PM
Origin Ver.: 8 SR 1
Operating System: Windows XP
Hi,
I would appreciate your help in writing a script to subtract two sheets (baseline from rawdata) in the same book. The following script that I wrote doesn't work:
loop (i, 1, rawdata.ncols) {
range a = [Book1]rawdata!Col(i);
range b = [Book1]baseline!Col(i);
range c = [Book1]data!Col(i);
c = a - b; }
Thank you in advance for your help! |
| 3 L A T E S T R E P L I E S (Newest First) |
| elena_loginova |
Posted - 10/12/2009 : 8:35:55 PM
Thank you! |
| cpyang |
Posted - 10/07/2009 : 9:26:10 PM
instead of col($(i)), better use wcol(i).
CP
|
| elena_loginova |
Posted - 10/07/2009 : 6:33:55 PM
It might be useful to somebody else. I understood, why it doesn't work: I had to use $i instead of i.
loop (i,1,1000) {
range a = [Book1]rawdata!Col($(i));
range b = [Book1]baseline!Col($(i));
range c = [Book1]data!Col($(i));
c = a - b;
}; |
