You'll have to excuse my clumsy scripting, but I think this will do it for you:
wks.addCol(C); // add column C col(C)=(col(B)/sum.total)*100; // calculate %ages sort.wksname$=Data1; // sort worksheet named Data1 sort.c1=0; // sort all columns; sort.r1=1; // sort range begin row 1 sort.r2=4; // sort range end row 4 sort.cname1$=D:C; //use col C as primary sort, descending sort.wks(); // execute sort
Addition of values in columns
Posted - 08/10/2005 : 06:37:02 AM
