LARGE

The LARGE function returns the nth largest number from a list of values.

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.

list - The list of numbers to iterate through

Example

Use the LARGE function to return the second-highest value among the 2024 and 2023 metrics.

LARGE([[2024 Actuals], [2023 Actuals], [2023 Plan]],2)

Use the LARGE function to find the 2nd highest value among plan and actual measures