GRID

The first column to produce the grid from. This can be a constant, a column, a single-column cell range, or any expression evaluating to one of the above.

col2

One or more additional columns to use in producing the grid. This can be a constant, a column, a single-column cell range, or any expression evaluating to one of the above.

Description

GRID generates a grid of all possible combinations of values using cells in each of the input columns. It returns a new column for each input column. If any of the inputs are constants, each value in the other input columns are paired with the that constant value.

Using the notation V1[1] for the first cell in column V1, V1[2] for the second cell, and so on, the expression GRID(V1, V2) would produce:

V1[1] V2[1] V1[1] V2[2] V1[1] V2[3] : : V1[2] V2[1] V1[2] V2[2] V1[2] V2[3] : : : :

All cells in column V1 are paired against each cell in column V2. GRID behaves similarly for more than two input columns. The number of rows generated is equal to the product of the length of the input columns.

The concatenated length of all of the input arguments cannot exceed

Examples

TEMP = GRID(1,2)

Creates two new columns named TEMP and VX, containing the values 1 and 2, respectively.

TEMP = GRID(COLUMN(1, 2), COLUMN(3, 4)) Creates two new columns named TEMP and VX. The rows across these two columns are: 1 3 1 4 2 3 2 4

TEMP = GRID(V1)

Creates a new column named TEMP containing a copy of the values in column V1.

TEMP = GRID(V1, 3)

Creates two new columns named TEMP and VX. The column TEMP is a copy of column V1, and column VX contains the value 3 for each row of column V1.

TEMP = GRID(V1, V2)

Creates two new columns named TEMP and VX, where each row represents one of the possible cell combinations (see description).

TEMP = GRID(V1, V3, V7)

Creates three new columns named TEMP, VX, and VY, where each row represents one of the possible cell combinations (see description).

Related Functions

Function	Description
SLIDE_WINDOW	Creates a pattern from a specified window and slides it down to create the next pattern