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