Hello,

If you like to sort with worksheet functions:
http://www.sulprobil.com/html/sorting.html

I would also suggest to use the COUNTIF() + COUNTIF() formula approach
instead of RANK because you might face identical sort keys or (in
other tasks) non-numerical sort keys for which RANK would not work.

Regards,
Bernd