RANK

Syntax:

RANK(array)

Ranks the values contained in the array, producing as an output an array with two columns: {rank,entries}.

The rank is the rank of each value (from highest to lowest). Entries contain the number of entries of that value in the input array.

The output from this function can be passed to the SPEARMAN function as it is in the format which that function expects.