...
10.9 Ranking of simple members
Here below is a data table:
To calculate the ranking of members (in descending order), and fill in the results in corresponding cell of column B, enter in cell B1:
=spl("=?1.conj().rank@z(?2)",A$1:A$10,A1)
Drag B1 down to every relevant row:
esProc Desktop and Excel Processing
10.8 Shuffle the data
10.10 Ranking of row-based data