View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hoytmedic Hoytmedic is offline
external usenet poster
 
Posts: 6
Default 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?