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.