`MAX()`

and `MIN()`

will allow the *largest* or *smallest* values in the array to be retrieved, but they don’t provide support for retrieval by *index*, as the OP requires.

(For anyone reading over Elias’s shoulder unclear on what I mean by that, here’s an illustration: Start with a 5-element array with the following values:

```
array[0] = 12
array[1] = 8
array[2] = 0
array[3] = 17
array[4] = 9
```

(Airtable would return that array — for instance, if you did a rollup on `{array}`

from a linked record using `ARRAYJOIN()`

— as `'12,8,0,17,9'`

. Performing a rollup using `MAX(values)`

would return `17`

, while one using `MIN(values)`

would return `0`

.

(The original poster, on the other hand, wanted the values of the first and last elements of the array — in this case, the values of `array[0]`

and `array[4]`

, or `12`

and `9`

, respectively. And that bracketed number following the word ‘array’ is known as the *index* of that specific array element: `array[3]`

would mean the value of the array element with an index of `3`

(in this case the *fourth* element, since indexing begins with `0`

), or `17`

.)