View Single Post
  #1   Report Post  
Jake
 
Posts: n/a
Default Average of Numbers in Top 5

How do I tell excel to look at only the top x numbers in a list of values?
For example, if I have 100 scores and I want Excel to calculate the average
of the top 10 scores, how do I do that?

Thanks