With worksheet active, invoke the menu item Analysis->Extract Worksheet. A dialog will come up, in which you can specify a condition string such as: col(B)[i]<0.5 && col(A)[i]>0.1 and then a new worksheet will be created with the filtered result. In this example, new worksheet will contain only those rows where column A had values greater than 0.1 AND column B had values less than 0.5
filtering raw data
Posted - 07/29/2004 : 3:56:48 PM
