Try this...

=IF(A2="","",RANK(A2,A$2:A$7))

--
Biff
Microsoft Excel MVP


"kent" wrote in message
...
I have 2 coulumns of data,
A is the score, and B is the ranking in descending order of A
WHat should be the formula in column B oplease?


A B
76 4
88 2
99 1

85 3
24 5
---------------------

Kent