Declaration: TDataTable.MinMaxOfValidCells (LowCol, LowRow, HighCol, HighRow: integer; var Minimum, Maximum: double): integer;
The method MinMaxOfValidCells calculates the minimum and the maximum value of all data table elements within a specified range of cells which are neither marked as csNAN, nor as csUndefined (that is which contain valid numeric and categorical values). The range of the data table elements to be used is determined by the parameters LowRow, LowCol, HighRow, and HighCol. If any of these parameters receives an invalid value, this value is automatically adjusted to the nearest boundary value (either 1 or NrOfColumns / NrOfRows).

The variable parameters Minimum and Maximum return the lowest and the highest value of the selected data. The function returns the number of data points used for the calculation (i.e. the number of numeric data cells within the specified range).

Hint 1: Setting both the low and high parameter of a dimension (i.e. LowCol and HighCol) to zero values forces the method to use all elements of that dimension.

Hint 2: In the case of ordinal and nominal variables the ordinal numbers of the data are used for the calculation.