Hello Biff,

...
Do not use RANK

Why don't you say something like:

Here's an alternative if you want to do this or this.
...

Because I do not use RANK anymore.

But surely we both can ask the OP next time what he needs to get in
case of identical keys.

(1) If he is happy with identical ranks then its RANK for him,
(2) if he needs unique ranks he can use Teethless' RANK + COUNTIF -1,
(3) if its no longer numbers but strings he can use COUNTIF + COUNTIF,
(4) and if there are more than one rank/sort levels then it might be
SUMPRODUCT.

COUNTIF + COUNTIF is not the fastest solution for (1) and (2) but it
kills the first three birds (1)(2)(3) with one stone:
http://sulprobil.com/html/rank.html

Regards,
Bernd