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

Adding sequence numbers to paragraphs 0
Trying to find additional ranges outside of min, max, and average 2
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Cell data entering slow! 0
averaging multiple items from one list 2
Excel and consecutive number 2
Goal Seeking via Excel 0
Return Column Header from an Index/array, finding Large with a userinput date 0

Top