Hi,

Try this and copy down:
=RANK(H6,$H$6:$H$17,0)+COUNTIF($H$6:H6,H6)-1

Regular formula, Don't need to array entered.

Blessing