ColumnRel
Returns the column number of the cell to which the function is attached, in relation to another cell.
Syntax
ColumnRel(reference)ColonneRel(reference)
reference = reference of the cell in relation to which you want to retrieve the column number
Remarks
The referenced cell's column number is 1.
This function is only available for formulas attached to a cell in a grid. It is used to obtain column numbers within a table. References to cells in a different layer are not allowed, so the reference must not include a layer name.
If the reference is a named range covering multiple cells, the top left cell in the range will serve as the basis for the function.
To retrieve a row number within a table, see LineRel.
For the column's absolute name, see Column.
Examples
ColumnRel(B2) = 1 for cell B2, 2 for cell C2, etc.