Help with formulas - urgent

[aly1cat]

I am trying to create a table whereby all companies are given a
rating/position according to the points scored, against a set of
criteria given - ratings of which can be anything between one and ten.

Ten being the highest.
The maximum score is obviously 80 (eight categories)

The rating put in will be manual but I need a formula that will
calculate the amount and then look at the highest score and then
provide a position number. i.e scores given to individual companies
are 80,64,23,10,46.
so what I want the formula to do is give a 1 for 80, 2, for 64, 3 for
46, 4 for 23 and 5 for 10.

I have enclosed a simple spreadsheet in hope that someone can help with
the formula.
Thanks a quick response will be welcomed.

Attachment filename: problem.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=414980

 

[Frank Kabel]

Hi

you can use the function RANK. In your exmaple spreadsheet enter the
following in cell E17:
=RANK(E16,$E$16:$K$16,0)
copy this for the entire row

HTH
Frank

 

[Earl Kiosterud]

aly1cat,

Another possibility is to sort the table in descending order on the score
column. If you haven't used Excel's sort before, be careful. Don't select
just a column!