wow, there's a function I've never used before! Can't really wrap my mind
around how 2/count() removed the highest and lowest values though. I get the
correct number anyway. Help for the function describes that argument as the
% to exclude from the calc. Would have never guessed it could mean the
actual top and bottom values.

Thanks for the help.

Robert

"Ron Coderre" wrote:

Try this:

With
A1:I1 containing numbers

This formula trims the high and low from the range and calcs the average
J1: =TRIMMEAN(A1:I1,2/COUNT(A1:I1))

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"frosterrj" wrote:

What would be the best way to use the avg() function (or any other
appropriate function) on a column or row while excluding the highest and
lowest value?

is this possible in one cell, or does it have to be split up using min() and
max() somewhere to exclude the value?

Thanks,
Robert