Perhaps this would be a good application of the TRIMMEAN function.

For a list of numbers in A1:A10
Where you want to exclude the MAX and MIN values

B1: =TRIMMEAN(A1:A10,2/10)
or...for more flexibility
B1: =TRIMMEAN(A1:A12,2/ROWS(A1:A12))

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

XL2002, WinXP


"Larry4500" wrote:

Is there a way to get Excel to ignore the max and min of a data range
when calculating the average? If so, is there any way to get it to
ignore the two highest and lowest values? The second question is less

important but I would really appreciate it if somebody has the answer
to my first question- it would be really useful for what I'm trying to
do. Thank you!