Average question

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
 
M

Max

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
Excel and consecutive number 2
Find Smallest and Largest. 5
AVERAGE 7
Automatic Sorting? 6
Average of Subtotals in Pivot Table 0
Find X number of smallest values in a range 1
Excel Average dates help 0

Top