Hi T. Valko

Thank you for your input.

Sorry but that's not possible. I put in the numbers:

Jan Feb Diff Rank
A 10,8 10,8 0,0 10
B 8,8 7,2 -1,6 15
C 11,9 11,4 -0,5 11 OK
D 7,8 5,6 -2,2 16
E 11,6 10,0 -1,6 14
F 7,5 7,0 -0,5 11 OK
G 8,2 9,6 1,4 5
H 8,5 11,2 2,7 1
I 13,0 13,6 0,6 8
J 6,0 7,8 1,8 3 !!
K 4,6 7,2 2,6 2
L 9,4 11,2 1,8 4 !!
M 10,6 11,5 0,9 7
N 13,7 15,0 1,3 6
O 9,3 9,5 0,2 9
P 11,1 9,8 -1,3 13


C and F is OK, but J and L should be rank 3 both.

--
Stone


"T. Valko" skrev:

The 2 values are probably not equal. There is probably a very small decimal
difference. If the values are decimals and are formatted to display in a
certain way they may *appear* to be equal but really are not.

For example:

10.025
10.031

If you *format* those values to *display* 2 decimal places:

10.03
10.03

They appear to be equal but the *displayed value* is not the true value. The
true values are 10.025 and 10.031 which are the values RANK is calculating.


--
Biff
Microsoft Excel MVP


"Stone" wrote in message
...
Hi

Using "RANK" should automatically rank eg. 10 observations from 1 to 10
and
if 2 observations have the same value they should rank eg. 7 and 7 and the
next rank would then be 9.

I have made several collums and for som collums this is actually so.
However
in som collums the ranking for two equel values is eg 7 and 8. Therefor
the
same "rules" dos not aply for this collums.

Can somone explane this to me or even better come up with an solution.

PS: Sorry for my english (I am for Denmark)

--
Stone