On Sun, 7 Dec 2008 11:36:39 -0600, "Charter"
wrote:

I'm working on a spreadsheet that scores on five different categories and
weighing them differently. I've figured out the scoring part and the
weighing part but now I'd like to have Excel automatically rank the scores
by putting a 1, 2, 3 in a cell beside the individual's name. Can this be
done?

Thanks,

Tom

Assuming your scores are in cells A1 to A10.
Try this formula in cell B1:

=RANK(A1,A$1:A$10)

Copy it down to B10.
(The 10 should be changed to fit the number of rows in your score
column)

Hope this helps / Lars-Åke