The data within a worksheet can be collectively filtered or bounded using the Filter command on the Data Worksheet window. With this command all records are scanned and if a record falls outside of the specified Range to Use, the variate outside of its range will be treated as missing values during the data build.
In these fields specify how to constrain the data in the Worksheet to a particular range. In the example shown, only those records for which the X direction field is within the range of 0.06 to 40.00 will be included in analyses even though there are records across the entire range of 0.60 – 79.90 in the worksheet; records outside of the 0.06 – 40.00 range will be treated as missing values in the worksheet when the analysis arrays are built (when the Rebuild button is pushed). Although Worksheet values are treated as missing during data builds, they are not marked as missing in the Worksheet.
The number of decimal places used to define the range is limited to the number of decimal places specified for the given coordinate field in the Field Assignment Dialog of the Data Worksheet Window. Changing the number of decimal places for a coordinate in the Data Worksheet Window changes the number of decimal places reported here.
Reset Range to Use to the actual data range for a given coordinate or variate. Data ranges can be set individually or (with the Reset All command) all at once.
Cancel filter dialog.
Accept the ranges specified. Note that for the filter to take effect you must check the filter box on the Worksheet window.