Posted - 10/24/2010 : 12:32:44 AM Thank you so much,greg! I'm really happy! The script you write really works!Now I can deal with my data quickly!
greg
Posted - 10/21/2010 : 10:14:46 AM So the first part of your script would be // BEGIN SCRIPT // Subtract first column A entry from entire column Col(A) = Col(A)-Col(A)[1]; // Similar for B Col(B) = Col(B)-Col(B)[1]; // Add two columns worksheet -add 2; // Creates 'C' and 'D' only if 'A' and 'B' exist // Calculate column C from columns A and B Col(C) = Col(A)*Col(B); // Calculate column D from columns A and C Col(D) = Col(A)*Col(C); // END SCRIPT