nthMostFrequent(n, cellRange)

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

Parameters

n the nth most frequent occurring value to search

cellrange the start and end of cell range whose

nth most frequent value is to be calculated

Return

nth most frequent occurring value in a cellrange

Example

text=

nthMostFrequent(2,'[1,state]:[5,state]');

See Also

nthMostFrequent(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.

<< nthLargest(n, cellRange) © 1996-2013 InetSoft Technology Corporation (v11.5) nthSmallest(n, cellRange) >>