Ranking numbers
 

try:

=RANK(A1,$A$1:$A$10,1)+(COUNT($A$1:$A$10) + 1 - RANK(A1,$A$1:$A$10, 0) -
RANK(A1, $A$1:$A$10, 1))/2

This is using correction factor as described in HELP for RANK function.

HTH

"Joff" wrote:

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.