If you are trying to Rank a range of values where some numbers are equal (75 in your example), and you do not want a tie, i.e., second equal in your example, you will have to find a way to add or subtract an extra value to the equal numbers to make them not quite equal but without changing their overall position in the rankings.
I used an extra column which subtracts a small increment.
Place your numbers in cells A1 to A6
In cell B1 enter this formula:
=IF(COUNTIF($A$1:$A$6,A1)>1,A1-CELL("row",A1)/100000,A1)Note the $ signs.
Drag the formula down to B6
In cell C12 enter this formula:
=RANK(B1,$B$1:$B$6)Note the $ signs.
Drag the formula down to C6
This is the result:
A B C
1 75 74.99999 2
2 75 74.99998 3
3 60 60 5
4 91 91 1
5 50 50 6
6 62 62 4
If this works for you, you can hide the extra column, or drag it to a column out of sight.