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.