# LARGE function

Returns the k-th largest value in a data set. You can use this function to select a value based on its relative standing. For example, you can use LARGE to return the highest, runner-up, or third-place score.

## Syntax

LARGE(array,k)

Argument

Description

Remarks

array

The array or range of data for which you want to determine the k-th largest value.

• If this argument is empty, this function returns the #NUM! error value.

k

The position (from the largest) in the array or cell range of data to return.

• If this argument is equal to or less than zero, this function returns the #NUM! error value.

• If this argument is greater than the number of data points, this function returns the #NUM! error value.

## General remarks

If n is the number of data points in a range, then LARGE(array,1) returns the largest value, and LARGE(array,n) returns the smallest value.

## Example

To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.

 1 2 3 4 5 6
 A B Data Description 3 4 5 2 3 4 5 6 4 7 Formula Description (Result) =LARGE(A2:B6,3) 3rd largest number in the numbers in the table (5) =LARGE(A2:B6,7) 7th largest number in the numbers in the table (4)
 Rate this content: