How can I take average of middle 3 values?
Posted by Steve on January 08, 2002 6:51 AM
Let's say that I have 5 numbers, A1,A2,A3,A4,A5
I'd like to be able to make excel take the average of this set, excluding the highest and lowest value. I know I could sort them, and take average of A2,A3,and A4, but I'd like to avoid doing that. Thanks for any help in advance!!