Sunday, July 10, 2011

Excel average formula excluding the lowest & highest 5%?

I have a list of numbers. I need a formula which will tell me the average of those numbers excluding the highest & lowest 5%. The numbers can't be sorted or cut and the amount of rows changes each month.

No comments:

Post a Comment