One way:
=(SUM(rng)-MIN(rng))/(COUNT(rng)-1)
This assumes that you mean to drop only one value if there are multiple
instances of the "lowest number".
In article ,
"thomas wald" wrote:
I need a formula that will figure the average of any range of numbers
dropping the lowest number
Thomas Goldstein
|