RANK

Syntax:

RANK( data:Range or Array )

Ranks the values contained in the data range of cells (or array).

Returns an array with two columns: { rank, entries } :

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