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