View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hoytmedic Hoytmedic is offline
external usenet poster
 
Posts: 6
Default Finding highest values

First off, thanks to all who helped me before, works great!

I have rows with multiple info, i.e. name, age, sub-event score and a final
total score. Is there a way I can have a second sheet sort through these
scores and keep a constantly updating "top four" in each age group? The "top
four" would be the top four FINAL scores from each AGE group. The tie
breaker for any ties is the value listed as TIME. I know I can do this as a
sort, but I would like this on a seperate sheet and constantly updating.

Am I asking too much?