| T O P I C R E V I E W |
| pink-lisa |
Posted - 01/15/2007 : 09:37:37 AM
Origin Version 7
Operating System:xp
hi
I have a spreadsheet of many columns of data. I would like to change the alternate columns:
1240 divided by the column value
how can I do this?
cheers
Lisa
xxx |
| 2 L A T E S T R E P L I E S (Newest First) |
| pink-lisa |
Posted - 01/15/2007 : 1:34:54 PM
Cheers, Mike! |
| Mike Buess |
Posted - 01/15/2007 : 1:20:22 PM
Hi Lisa,
The following script will change columns 1, 3, 5, ... to 1240 divided by same columns. Use ii=2; to change columns 2, 4, 6, ...
ii=1;
for(i=ii; i<=wks.ncols; i+=2) {
wcol(i) = 1240 / wcol(i);
};
Mike Buess
Origin WebRing Member |
|
|
