OK, yes, instead of the scores you could just use the ranks, perhaps that would be simpler, i.e. this version in D4

=COUNTIF(C$4:C$19,">"&C4)+(COUNTIF(C$4:C$19,C4)+1)/2