Average 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
2009 - 2016
2009 - 2016
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