Allocate points according to rank - Tie problem

Hi all,
I am keeping scores for a tournament. this tournament consists of aprox. 14 matches. In these matches you can earn points, that will make up a final tournament ranking. I have found formulas for allocating points to scores, but they don't work for me as they don't solve the tie problem. when for example the 4th and 5th in a match have the same score, they each get the points for the 4th place(being 40points) and the player in position 6 should get 36 points (not the 38 points for 5th, these are NOT allocated).
Your help and expertise in this matter would be appreciated.

example data in att.

What formula are you using, Rank should cater for that.

=IF(RANK(A1;A$1:A$41)<40;LOOKUP(RANK(A1;A$1:A$41);{1;2;3;4;5;6;7;8;9;10;11;12;13;14;15;16;17;18;19;20;21;22;23;24;25;26;27;28;29;30;31;32;33;34;35;36;37;38;39};{50;45;42;40;38;36;34;33;32;31;30;29;28;27;26;25;24;23;22;21;20;19;18;17;16;15;14;13;12;11;10;9;8;7;6;5;4;3;2}); 1)

this is a formula I found on a forum, I changed the points to fit the tournament rules.