Hi:
Right now for 80, you can use some script to implement that. The following script extract subgroup data into new worksheets.
// The source worksheet, which is the current active worksheet
range wk = !;
range f2 = !col(f2);
// Create a hidden book to hold the result of frequency count
newbook r:=tmpbook hidden:=1;
// Do frequency count
discfreqs f2 rd:=[tmpbook$]!;
// Wait for the X-Function complete
run -p au;
// Get the unique data
range cnt = [tmpbook$]sheet1!col(1);
// Loop to extract data into new worksheet
for(ii=1; ii<=cnt.getsize(); ii++)
{
double dd = cnt[ii];
wxt test:="f2==$(dd)" iw:=wk ow:=[<input>]<new F2_$(dd)>;
}
// Delete the temp hidden workbook
win -c %(tmpbook$)
Thanks
Larry
OriginLab Technical Services