Hi,

You should simplify the formula to read:

=RANK(A1,A$1:A$9) for descending
=RANK(A1,A$1:A$9,1) for ascending

using A1:A9 for the first argument instead of A1 gains nothing and is
overkill.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Dennis Noble" wrote:

Formula Rank=(A1:A9,A$1:A$9,1) this is working well but! I need to reverse
the order to high # equal 1st not last