I'm still confused
I know some have helped on this before, but I cant seem to get it right.
Heres what I have
A Name Age Time Score
B Bob 8 12.2 56
C Sue 12 13 72
etc
NAME is in column C
AGE in column D There are only three ages 8, 10 and 12
TIME in column K
SCORE in column L
There is some unimportant info in the other columns
I would like to have it show me the highest four scores in each age group,
for a total of 12. I would like this to be a function, not resort the whole
list, so it is up-to-date all the time. In the event of a tie in an age
group, the lowest time ranks higher.
Any help?
|