Try the RANK() function:

=RANK(A2,$A$2:$A$10,0)



"Andy" wrote in message
...
Is there a formula or function I can use to change the Value in Column B
based on the value changed in Column A Pelase see e.g below
Col A Col B
24 6
53 1
40 2
34 5
38 4
38 4
25 5
23 5
39 3
Whenever I see the highest Value it should get 1 then next highest 2 and
so
on. When 2 numbers are same then they get equal points.


Thanks
AM