Change the 1 in your formula to a 0.
--
If this helps, please click the Yes button. Thanks!

Allllen


"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