Try in K7 (?)
=rank(I7,$I$7:$I$11) and copy down to K11
Note you need to decide whether Ties are allowable. and add a tie breaker
somewhere if not
in L7 enter "Winner"
in L8 enter "Second" (note if ties are allowed you may have to play with
this one)
maybe =if(countif(I7:I11,1)1,"Winner","Second"
Do similar things for L9-L11
In M7 enter
=index(H$7:H$11,match(Row()-6,$K$7:$K$11,0))
Copy to O11
Add your labels to M6:O6 and print L6:O11

"SYBS" wrote:

This is what I have. I have arrived at this with scores taken from 5 score
sheets per competitor, the top and lowest scores (each) have been discarded
and what I am left with is the three middle scores calculated on this results
page, (calculation formulas etc are hidden columns because this page is to be
printed off and I dont want the individual judges scores seen). The 3 are
averaged to give a winner, 2nd,3rd,4th, & 5th placing.

What I would like to do is for this list to automatically sort itself into
the correct running order and place a (1st), (2nd ), 3rd) etc before or after
the placings achieved. I can manually sort it by selecting a row number,
data, sort etc but it needs to be automatic. I have fumbled around trying
large, index, if etc, and cannot get it to work. Everytime the list sorts
itself it leaves some behind or automatically changes the formula to suit
itself ! Can you please help. I need to put this to bed today !

Many thanks.

COL H COL I COL J
CLIMBERS SCORE TIME
ROW7 RUPERT WILKINSON 41.67 27.40
ROW8 LEE TOULSON 46.00 20.91
ROW9 GAVIN RODDERS 13.33 26.15
ROW10 JONTHON TURNBULL 10.00 24.01
ROW11 SAM ROBINSON 6.67 23.73