RANK

TEMP=RANK(V6)

Creates a new column named TEMP with each value, a one through ten, representing the bin of data that the row falls into. In this case, the default number of bins, 10, is applied.

TEMP=RANK(V6,15)

Creates a new column named TEMP with each value, a one through fifteen, representing the bin of data that the row falls into.

TEMP = REPEAT(3, V1:V3)

Creates three new columns named TEMP, VX, and VY. TEMP contains three copies of column V1, VX contains three copies of column V2, and VY contains three copies of column V3. Any uneven length columns are padded to the length of the longest column of V1 - V3.

TEMP = REPEAT(10, V1[10:50]:V2)

Creates two new columns named TEMP and VX. The values in column TEMP are 10 copies of rows 10-50 of column V1, and the values in column VX are 10 copies of rows 10-50 of column V2.

TEMP = REPEAT((1,2,3), (10, 20, 30))

Creates one new column named TEMP, containing the cell values 10, 20, 20, 30, 30, 30.

TEMP = REPEAT(V1, V2)

Creates one new column named TEMP. The value in cell V2[1] is repeated V1[1] times, the value in cell V2[2] is repeated V1[2] times, and so on until the end of column V1.

TEMP = REPEAT(V1, V2:V3)

Creates two new columns named TEMP and VX. The TEMP column contains copies of cells in V2; the VX column contains copies of cells in V3. There are V1[1] copies of V2[1] and V3[1], V1[2] copies of V2[2] and V3[2]. This continues until the end of column V1 or the end of the longest column in data, which ever is shorter. Shorter columns in data are padded with zeros.

TEMP = REPEAT(3, V1, COL)

Creates three new columns named TEMP, VX, and VY, each a copy of column V1.

TEMP = REPEAT(2, V1:V2, COL)

Creates four new columns named TEMP, VX, VY, and VZ. Column TEMP is a copy of column V1; column VX is a copy of column V2, column VY is a copy of column V1; and column VZ is a copy of column V2.