Use the LARGE function to find the highest values - Basic Statistical Functions - Microsoft Excel Tutorials

Use the LARGE function to find the highest values using Microsoft Excel

To determine the highest value in a list, we used the MAX function. To find out multiple high values of a range, the LARGE function can be used. This function returns the nth highest value in a set of data.

LARGE(array, n)

array: Array or range of numerical data in which we want to find the nth highest value.
n: The position from the highest in the array or range of data to return.

To determine the three highest values of a range:

1. In cells A2:C10 type any values from 0 to 99.
2. Number cells A12, A13, and A14 with 1, 2, and 3.
3. Select cells B12:D14 and type the following formula:=LARGE(B$2:B$10,$A12).
4. Press <-Ctrl+Enter->.

Use the LARGE function to find the highest values