Hi folks,

Anyone know how to go about creating a formula that can be used to ignore (ie not remove bu simply set to zero) the highest and lowest values from an array of values..?

Value 1 - 9 (ignore)
Value 2 - 3
Value 3 - 4
Value 4 - 5
Value 5 - 7
Value 6 - 2 (ignore)

Using the above data I would like to calculate an average but I'd like to strip-out the highest and lowest value from the calculation....

Another consideration is calculation of a weighted average value where the highest and lowest value are given a much lower weighting that the other values.

Value 1 - 9 (weight = 0.5)
Value 2 - 3 (weight = 1.0)
Value 3 - 4 (weight = 1.0)
Value 4 - 5 (weight = 1.0)
Value 5 - 7 (weight = 1.0)
Value 6 - 2 (weight = 0.5)

Again - I'd like to determine a weighted average but values 1 and 6 are given differing weights...

Any thought..?

Regards,

Dan