Average the Largest 3 Values

Averaging the Largest 3 Values

The following formula returns the average of the largest 3 values in A2:A10...

=AVERAGE(LARGE(A2:A10,{1,2,3}))

Based on the sample data, the formula returns 85.

Sample Workbook: Download