Gradings

[Cossie]

I have a set of numbers that i want to grade from 1 - 6

A B
22 5
12 2
15 3
25 6
5 1
19 4

is there a formula that will work out column B for me??

Thanks
This message was edited by Cossie on 2002-11-03 18:15
This message was edited by Cossie on 2002-11-03 18:21

 

[Aladin Akyurek]

No examples?

 

[PaddyD]

check the help for rank()

paddy

 

[Cossie]

thanks that is what i needed