| T O P I C R E V I E W |
| DanielHenry |
Posted - 06/16/2020 : 3:19:11 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)omegle xender
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. |
| 1 L A T E S T R E P L I E S (Newest First) |
| nick_n |
Posted - 06/16/2020 : 4:22:23 PM
Hi,
Try to modify:
col(3)[ii]=90-col(2)[ii];
Regards,
Nikolay |
|
|
