Did you check out the link I gave you the other day, i.e.:

http://www.cpearson.com/excel/rank.htm

I thought this explains things very well, though you might need to
tinker with the formulae as you have 3 age groups in the same data
set.

Hope this helps.

Pete

On Jul 6, 9:26 pm, Hoytmedic
wrote:
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?