# Learn How to AVERAGE Top 3 Scores in Microsoft Excel

Written by | 0 Comments | 284 Views

In this article, you will learn How to AVERAGE Top 3 Scores in Microsoft Excel using a single/combination(s) of functions. You will also know How to AVERAGE Top 3 Scores and see the generic formula.

AVERAGE Top 3 Scores in Microsoft Excel

The main purpose of this formula is to average the top 3 scores in a data set. Here we will learn how to get the average of the top three scores in the data range in the workbook in Microsoft Excel. That implies, with the help of a formula based on the AVERAGE and LARGE function you can able to average the top 3 scores in a data set. So, with the help of this formula, you can able to get the average of the top three scores in the data range in the workbook in Microsoft Excel.

General Formula to AVERAGE Top 3 Scores

=AVERAGE(LARGE(range,{1,2,3}))

The Explanation for the AVERAGE Top 3 Scores

So we know that with the help of the given formula above you can able to average the top 3 scores in a data set. Here we will learn how to get the average of the top three scores in the data range in the workbook in Microsoft Excel. As we know that the LARGE function is designed to retrieve the top nth value from a set of numbers. That implies in the following data set LARGE(A1:A10,1) will return the highest value, and in this data  LARGE(A1:A10,2) will return the 2nd highest value, and so on. So, with the help of this formula, you can able to get the average of the top three scores in the data range in the workbook in Microsoft Excel.