| T O P I C R E V I E W |
| EmiliaSeltsam |
Posted - 04/29/2020 : 5:58:52 PM
Origin Ver. 2016G
Operating System: Windows 10
I like to perform simple calculation on data in a column, but use only selected rows.
If I use the Command Window I can do:
col(C)=90-col(B)
which will perform the calculation on all rows.
I want the calculation on every 3rd row, i.e. 1st, 4th, 7th ... and the other data should be just copied as they are.
I tried:
for (ii =1; ii <=wks.maxrows; ii +=3)
{col(3)=90-col(2)[ii]}
but this gives a constant value in the 3rd column.
Can anyone help? Thanks. |
| 4 L A T E S T R E P L I E S (Newest First) |
| EmiliaSeltsam |
Posted - 04/30/2020 : 01:28:35 AM
 yes, it basically works.
I cleared col(3) and then performed the script, and it does the calculation on every 3rd row.
But it does not copy the other data from col(2).
My workaround is to copy col(2) to col(3) and then run the script, which gives me what I want.
THANKS A LOT. |
| aplotnikov |
Posted - 04/29/2020 : 6:49:52 PM
I have checked - everything works fine. You may need to initialize the third column before calculations.
|
| EmiliaSeltsam |
Posted - 04/29/2020 : 6:39:11 PM
Thanks for the fast reply :-)
But problem remains the same: col(3) is filled with the same value on all rows ... |
| aplotnikov |
Posted - 04/29/2020 : 6:33:26 PM
col(3)[ii]=90-col(2)[ii] |
