That works but ecludes the top and bottom %. Ie if you have 4 values - it
will only average the middle two if you use 25% trim.

But thanks for the try !

"ScottO" wrote:

Take a look at the function TrimMean - refer to in-built help for syntax.
It does the same as average, but gives you the ability to set what % of
"extreme" values to ignore.
This may not suit your purpose if you only want to omit the one lowest
value, but worth a look anyway.

Rgds,
ScottO

"ynissel" wrote in message
...
| Is there a function to average a series of numbers but dropping the lowest
?
| Thanks,
| Yosef