# SMALL

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

## Syntax

```javascript
small(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 SMALL function to return the second-highest value among the 2024 and 2023 metrics.

```
SMALL([[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%2FDogAXnvh8NqWHOcBxQWa%2Fimage.png?alt=media&#x26;token=0351469c-9b94-4c74-9050-4bb9a511778f" alt="How to use the LARGE function to calculate the second smallest value among the 2024 Actuals, 2023 Actuals and 2023 Plan measures"><figcaption><p>Use the SMALL function to calculate the second largest value among the actual and plan measures</p></figcaption></figure>