Try something like:

=AVERAGE(IF(A1:A5MIN(A1:A5),A1:A5))

Array-enter the formula, i.e. press CTRL+SHIFT+ENTER
instead of just pressing ENTER

Adapt the range to suit
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Judge" wrote:

Is there a function command that will average a group of numbers while
dropping the lowest number automatically?