RANK

Syntax:

RANK(data:array|range)

Ranks the values contained in the data array (or range of cells). 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.