Investment Studio > Expressions > Functions > Reference > COLUMN
| Implicit form: | integer column() Returns the column number of the cell containing the expression. |
| Scalar form: | integer column(reference cell_reference) Returns the column number of the referenced cell. |
| Array form: | integer array[1][*]
column(reference range_reference) Returns a row vector with the referenced column numbers. |
Examples
=column()
in cell B9 of the spreadsheet in the Macros view returns 2 (for column B)
=column(C3)
returns 3 (for column C)
=column(E4:G5)
returns {5, 6, 7} (for columns E, F, G).