LARGE

Returns the nth largest value from a list to help identify top or ranked numbers within a dataset.

The LARGE function returns the nth largest number from a list of values by identifying the value at the specified rank when the numbers are arranged from highest to lowest. It is commonly used to determine top values, rankings, or threshold levels within a dataset.

Syntax

LARGE(index, list)

Arguments

index - The index specifies which largest value to return—for example, 1 returns the largest, 2 returns the second largest, and so on (Required).

list - The list of numbers to iterate through (Required)

Example

LARGE([[LIST],INDEX)

In the example below, the LARGE measure is created using the LARGE function, which returns the nth largest value from the measures MEASURE 1, MEASURE 2 and MEASURE 3.

Applying LARGE Function