Hi JL,
If your data is large, it may be not very convenient to perform these manually. I suggest using LabTalk to complete it.
For Question 1, You can use the following script:
maxcol = wks.nCols; //Get the number of columns in the worksheet
nn = maxcol - 1; //The rightmost column to delete
for (ii=nn; ii>=3; ii-=2)
{
%a = %(%h, $(ii)); //Get the dataset of the column to delte
delete %a;
}
Make the worksheet that has the data active. Then copy the script into the Script Window (can be opened by selecting Window: Script Window). Highlight the script and type enter.
For question 2, the following script should work:
for (ii=2; ii<=10; ii++)
{
%a = %(%h, $(ii)); //Get the dataset of a column
%b = %(%h, $(ii), 9); //Get the value in the 9th row (offset)
%a -= %b; //Deduct every value in the column by the offset
}
Deanna
OriginLab Technical Services
