10.9 Ranking of simple members

 

Here below is a data table:

imagepng

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)

imagepng

Drag B1 down to every relevant row:

imagepng


esProc Desktop and Excel Processing
10.8 Shuffle the data
10.10 Ranking of row-based data