Here is a solution based upon a suggestion in John Walkenbach's Excel
2003 Formulas. Enter the following array formula in a single cell:
=AVERAGE(LARGE(ColumnRange,ROW(INDIRECT("1:3"))))

Here ColumnRange is the given range of numbers. In this example, the
average of the largest 3 is computed.

George Monahan