G
Guest
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 don’t 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
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 don’t 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