Check out the RANK worksheet function.

Syntax

RANK(number,ref,order)

Number is the number whose rank you want to find.

Ref is an array of, or a reference to, a list of numbers. Nonnumeric values
in ref are ignored.

Order is a number specifying how to rank number.

If order is 0 (zero) or omitted, Microsoft Excel ranks number as if ref were
a list sorted in descending order.

If order is any nonzero value, Microsoft Excel ranks number as if ref were a
list sorted in ascending order.

"pytelium" wrote:


I have 3 columns as shown in attached sheet. This is the start of a
large sheet,column 1 shows the first 4 events .
There are a series of scores for each event in cols 2 and 3. I need the
following cols 4 and 5. In col 4 print the rank order of the scores for
first event form col 2,highest is 1 , 2nd highest is 2 etc. Similairly
in col 5 I want the rank order printed for the scores in col3.


+-------------------------------------------------------------------+
|Filename: march.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4428 |
+-------------------------------------------------------------------+

--
pytelium
------------------------------------------------------------------------
pytelium's Profile: http://www.excelforum.com/member.php...o&userid=25521
View this thread: http://www.excelforum.com/showthread...hreadid=520342