I need to calculate the average of 5 values while dropping the lowest value from the average for example;
----B----C---D---E---F-----G
4 | 80, 90, 70, 65, 32 Average(excluding 32)
5 | 64, 95, 55, 0, 60 Average(excluding 0)
I need a way to get the average of the highest values while excluding the lowest value and I have to do it for several rows so typing out a specific equation for each wouldn't be optimal.
Bookmarks