Average question

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have a column (A) of 100 unsorted numbers. How do I get an average of the 5
largest and 5 smallest.

d
 
Try these, normal ENTER:
=AVERAGE(LARGE(A1:A100,{1;2;3;4;5}))
=AVERAGE(SMALL(A1:A100,{1;2;3;4;5}))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to find additional ranges outside of min, max, and average 2
Automatic Sorting? 6
Average of Subtotals in Pivot Table 0
Find Smallest and Largest. 5
Excel and consecutive number 2
Find X number of smallest values in a range 1
AVERAGE 7
Excel Average dates help 0

Back
Top