OFFSET

Offsets values within a column

OFFSET( column, number of rows)

Returns a reference to a row relative to the current row, determined by the input number of rows. If number of rows is 0, returns the current row.

Arguments

Output

Values in column, offset by the given integer

Example

Let's say we want to calculate the daily percent change in the SPY Index price. We could utilize OFFSET() in such a case to give us the previous day's price, allowing for a manual calculation of the daily percent change to then take place.

Last updated