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