INDEX

Returns the value at a given index inside a column.

INDEX(column, integer)

Returns the value at a given index within a column. Index starts at 1.

INDEX() and NTH() are aliases of each other.

Arguments

Argument

Description

column

Column to index

index

Index of value to return in column

Output

Value at index in column

Example

Last updated