Ignoring the higest values in an arry, and the average of the rest

[Guest]

I work ved arrays and lists with varying number of cells. How can I make a
formula, where I ( in a single column og row)want to ignore ex 10 % of the
higest values an take the average (Middle) of the rest.

 

[William]

I've assumed a range of numbers named "x". You wish to exclude
the top 10% from the average and that 10% figure is entered in cell A1.

The following is an array formula that should be entered by holding down
Ctrl|Shift|Enter simultaneously when entering the formula.
{=AVERAGE(IF(x<LARGE(x,INT(COUNT(x)*A1)),x))}


--
XL2002
Regards

William

(e-mail address removed)

| I work ved arrays and lists with varying number of cells. How can I make a
| formula, where I ( in a single column og row)want to ignore ex 10 % of the
| higest values an take the average (Middle) of the rest.