OFFSET

The values to compute the offset of. This can be a constant value, a column, a cell range, or an expression evaluating to any of the above. For the format definition of data, see the "Macro Function Parameters" section in the chapter in this guide for your IBM® product.

Description

OFFSET returns the values of the specified data range offset from the first value. It returns one new column containing the offset values, beginning with one and continuing to the length of the longest column in the data range.

Examples

TEMP = OFFSET(5)

Creates a new column named TEMP containing the value one.

TEMP = OFFSET(V1)

Creates a new column named TEMP, where each value is the offset of the column V1, starting with one and ending with the length of the column V1.

TEMP = OFFSET(V1:V3)

Creates a new column named TEMP, where each value is the offset, starting with one and ending with the longest column of V1, V2, or V3.

Related Functions

Function	Description
COUNT	Counts the number of cells containing values in the specified data range
DELAY	Returns the input column(s) values delayed by a specified number of time steps