Rank with duplicates

[ste33uka]

Hi is it possible to rank with duplicates , and giving the highestest rank 20 points, 2nd most 19 points ans so on.
Have attached snap shot for better understanding
Thanks

 

[Phuoc]

Try this:

=IF(B3="","",21-RANK(B3,$B$3:$B$30,0))

 

[jorismoerings]

Hi,

try this:
=SUMPRODUCT((B2<=$B$2:$B$17)/COUNTIF($B$2:$B$17,$B$2:$B$17))

 

[ste33uka]

Try this:

=IF(B3="","",21-RANK(B3,$B$3:$B$30,0))

Thanks alot, that works for me