VoseRank

VoseRank({data}, descending)

This array function returns an array with the ranks of the values from the input array. By default, the ranks in the list are sorted in ascending order, meaning that rank 1 is given to the lowest value.

When duplicates occur in the data, all of them are assigned the average of their ranks (which is more correct than Excel's RANK function that assigns the highest rank.)

{data} - the data of which the ranks are to be determined.
Descending - optional boolean parameter. Set FALSE (default) for ascending ranks, i.e. 1 = lowest data value. Set TRUE for descending ranks, i.e. 1 = highest data value.

When the output array is smaller in size than the {data} array, say n cells, only the ranks of the first n values of the input array are returned.

When the output array is larger in size than the {data} array it will return the ranks and fill up the remaining part of the output with #N/A errors.

VoseRank

Navigation