is this it?
=COUNTA($D$3:$D$8)+1-RANK(D3,$D$3:$D$8,1)