This formula uses Excel's LARGE function, which returns the nth largest value in a range. The formula adds the five largest values in the range named Data and then divides the result by 5. The formula works fine, but it's rather unwieldy. And what if you decide that you need to compute the average of the top six values? You would need to rewrite the formula — and make sure that you update all copies of the formula.

Wouldn't this be easier if Excel had a function named TopAvg? Then you could compute the average by using the following (nonexistent) function:

0 0

Post a comment