Please consider supporting this website by buying me a coffee.
Thank you for your consideration!
Updated | October 28, 2024
Average the Largest 3 Values
The following formula returns the average of the largest 3 values in B3:B12...
=AVERAGE(LARGE(B3:B12,{1,2,3}))
Based on the sample data, the formula returns 79.33.
Sample Workbook: Download