# LARGE

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

## Syntax

```javascript
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)
```

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FG5DtyqpS6FkfToewe4kO%2FScreenshot%202025-12-19%20152629.png?alt=media&#x26;token=3190f571-159a-4826-8a47-3c39c300ca73" alt="How to use the LARGE function to calculate the second largest value among the 2024 Actuals, 2023 Actuals and 2023 Plan measures"><figcaption><p>Use the LARGE function to find the 2nd highest value among plan and actual measures</p></figcaption></figure>