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