Use the LARGE function to find the highest values using Microsoft Excel
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->.
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 |
