ExcelBanter - Average question

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Average question (https://www.excelbanter.com/excel-worksheet-functions/182869-average-question.html)

Dave

Average question

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

d

Max

Average question

Try these, normal ENTER:
=AVERAGE(LARGE(A1:A100,{1;2;3;4;5}))
=AVERAGE(SMALL(A1:A100,{1;2;3;4;5}))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dave" wrote:
I have a column (A) of 100 unsorted numbers. How do I get an average of the 5
largest and 5 smallest.

d

All times are GMT +1. The time now is 02:44 AM.