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