Excel 2007 - I have a worksheet where column B is filled with random scores.
In column C I would like to have the corresponding score in column B ranked
against all the other scores in column B so it would rank each of the scores
between 1-10.

Example:
Column B Column C
9.56 2
10.12 1
8.11 4
8.99 3
etc.

If the value in column B changes (it sometimes does) then all the ranks in
column C should adjust accordingly. Is this possible?

Thanks!