To average the top 3 scores in a data set, you can use a formula based on the LARGE and AVERAGE functions. In the example shown, the formula in G6 is:
=AVERAGE(LARGE(B6:F6,{1,2,3}))
How this formula works
The LARGE...

To sum the top values in a range, you can use a formula based on the LARGE function, wrapped inside the SUMPRODUCT function. In the generic form of the formula (above), rng represents a range of cells that contain...

To get the 2nd largest value, 3rd largest value, 4th largest value, and so on, from a set of data, you can use the LARGE function.
In the example shown, the formula in J5 is:
=LARGE($C5:$G5,2)
How this formula works...

To return the largest values in a set of data with criteria, you can use the a formula based on the LARGE and IF functions.
In the example shown, the formula in F5 is:
{=LARGE(IF(B5:B11="B",C5:C11),2)}...

To get the 2nd largest value, 3rd largest value, 4th largest value, and so on, where each value matches supplied criteria, you can use an array formula that uses the LARGE and IF functions.
In the example shown, the...

To display a list of names, ranked by a numeric value, you can use a set of formulas based on LARGE, INDEX, MATCH, with help from the TEXT function. In the example shown, the formula in G5 is:
=LARGE(IF(TEXT(date,...

To highlight the highest values in a set of data with conditional formatting, you can use a formula based on the LARGE function.
In the example shown, the formula used for conditional formatting is:
=B4>=LARGE(...

To sum the top n values in a range matching criteria, you can use a formula based on the LARGE function, wrapped inside the SUMPRODUCT function. In the generic form of the formula (above), range represents a range of...

To dynamically sort a list of numbers in ascending order, you can a simple formula based on the SMALL function with an expanding range. In the example shown, the formula in cell C5 is:
=SMALL(data,ROWS($B$5:B5))...

To average the last 3 numeric values in a range, you can use an array formula based on a combination of functions to feed the last n numeric values into the AVERAGE function. In the example shown, the formula in D6 is...