LARGE function - The function returns the kth largest value in a dataset in Excel

The following article introduces you to the LARGE function - one of the functions in the statistical function group is very popular in Excel.

LARGE function - The function returns the kth largest value in a dataset in Excel Picture 1

Description: The function returns the kth value in the dataset. Use the function to determine the position of the value in a dataset.

Syntax: LARGE (array, k)

Inside:

- array : Array or range of data containing the kth largest value in it.

- k: What is the largest position (the largest ad is 1) in the array to return.

Attention:

- If the argument in the array is a blank -> the function returns the #NUM! Error value .

- If k ≤ 0 or k is greater than the number of data points in the array -> the function returns the #NUM! Error value

- If n is the number of data points of the array, then:

+ LARGE (array, 1) -> returns the largest value in the array array.

+ LARGE (array, n) -> returns the smallest value in the array array.

For example:

Find the kth largest value as described in the data table below:

LARGE function - The function returns the kth largest value in a dataset in Excel Picture 2

1. Calculate the 3rd and smallest largest values ​​in array1

- Calculate the 3rd largest value in array1. In a cell to calculate enter the formula : = LARGE (C6: C10,3)

LARGE function - The function returns the kth largest value in a dataset in Excel Picture 3

- Press Enter -> the 3rd largest value in array1 is:

LARGE function - The function returns the kth largest value in a dataset in Excel Picture 4

- Calculate the smallest value in array1. Using the LARGE up the smallest value in the array is the largest value in the array n where n is the total number of elements in the array -> enter the formula: = LARGE (C6: C10,5) ( array array1 5 parts death) -> press Enter -> minimum values ​​are:

LARGE function - The function returns the kth largest value in a dataset in Excel Picture 5

2. Calculate the 2nd and 3rd largest values ​​in array2.

- Because array2 has 2 equal elements of 6. Two equal values ​​but the function still ranks them in 2 different positions:

- Calculate the second largest value in the array -> enter the formula: = LARGE (D6: D10,2)

LARGE function - The function returns the kth largest value in a dataset in Excel Picture 6

- Press Enter -> the second largest value is:

LARGE function - The function returns the kth largest value in a dataset in Excel Picture 7

- 3rd largest value in the array -> enter the formula: = LARGE (D6: D10,3) -> press Enter -> 3rd largest value is:

LARGE function - The function returns the kth largest value in a dataset in Excel Picture 8

Thus the 2nd and 3rd largest values ​​in the same array are 6.

Above are instructions and some specific examples when using the LARGE function in Excel.

Good luck!