xl-central.com, Your Quick Reference to Excel Solutions





navleft
navright
spacer
Average the Largest 3 Values

Average the Largest 3 Values

The following formula returns the average for the largest 3 values in B2:B10...

=AVERAGE(LARGE(B2:B10,{1,2,3}))

Based on the sample data, the formula returns 85.  Sample Workbook



spacer
Wu Yi Tea
Website Designed by Wu Yi Tea
Design downloaded from free website templates.
Wordpress Themes