CELLCOL Function
The CELLCOL function returns the table column number of the current cell as a string into the current cell.
Syntax
CELLCOL(<cell number>)
If a cell number is specified, it returns the table column identifier of that cell starting at 1 for column A as a string. This reference must be a direct cell reference. If a cell is not identified, then the function returns the column identifier of the current cell.
It is also possible to use the CELLCOL() function in skip and hide conditions on table columns.
Example 1
Enter CELLCOL() in a table cell ABC.F1 returns 6, since F is the sixth letter of the alphabet.
Example 2
Enter CELLCOL(ABC.D135) returns 4, since D is the fourth letter of the alphabet.
This function provides an easy way to include table column information in such a way that it is re-referenced when columns are added or deleted or when a table is relabeled.
