nthLargest(n, cellRange)

Calculates the nth largest value in the specified column inside a cell range. This function is only available to fixed Table elements.

Parameters

n the nth largest value to search

cellrange the start and end of cell range whose

nth largest value is to be calculated

Return

nth largest value in a cellrange

Example

text=nthLargest(2, '[1,price]:[5,price]');

See Also

nthLargest(n, column[, group[,condition]]), for the Section version.

SI.6, Table Object , for additional functions pertaining to Tables.

Data Tables, for scripting issues related to fixed Tables.

<< mode(cellRange) © 1996-2013 InetSoft Technology Corporation (v11.4) nthMostFrequent(n, cellRange) >>