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 from 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.
There are about 700 events,some have up 20 rows.
Bookmarks