I need to rank the following numbers:

Entered Values What Excel has ranked What I actually want
1 2
2
15 7
7
28 9
9.5
5 4
4
28 9
9.5
10 6
6.5
10 6
6.5
2 3
3
0 1
0
56 10
10

This is for a fishing score data. The weight is the 'Entered Values' (and is
changeable week to week). I can get around the '0' that i actually want
(there might of course be another way), but am really struggling to get the
..5's sorted. Any help will be greatly apprieciated.