Hello, Rachel.
You may use Labtalk script to automate the sorting. Suppose you have 3 pairs of x and y columns, and they are arranged in the worksheet like:
X1, Y1, X2, Y2, X3, Y3
Then you can use the following code:
NumPairs=3;
for (ii=0; ii<NumPairs; ii++)
{
XIndex=ii*2+1;
type $(XIndex);
sort -cd $(XIndex) $(XIndex+1) col($(XIndex+1));
};
Paste the code into the Script Window, highlight all the codes and press enter. Then the worksheet will be sorted.
You may change the number of column pairs to suit your need, just by modifying the number (in red) in the first line.
Deanna
OriginLab GZ Office
multiple custom column sorting
Posted - 05/22/2006 : 12:27:10 AM
