Look up the TRIMMEAN function in Excel Help.

Will that do what you want?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)


"maryj" wrote in message
...
I'm trying to assist a client with this. He needs to find the mean of
numbers
with the exception of those that are very different from the rest -
outliers.
Can you give us some ideas of how to do this? He is trying to avoid adding
extra helper columns to do this.

Thanks.
--
maryj