After a quick edit, this is what my original post should look like!!

I need to rank the following numbers:

Entered Values Current Excel rank What I 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.