Definition of COLUMN
Returns the column number of a specified cell, with `A=1`.
cell_reference- [ OPTIONAL - By default, the cell containing the formula ] - The cell whose column number will be returned. Column
cell_referenceis a range more than one cell wide and the formula is not used as an array formula, the position of the first column in
ROWS: Returns the number of rows in a specified array or range.
ROW: Returns the row number of a specified cell.
COLUMNS: Returns the number of columns in a specified array or range.
In order to use the COLUMN formula, start with your edited Excellentable:
Then type in the COLUMN Formula in the area you would like to display the outcome:
By clicking on the cell you would like to calculate the COLUMN formula for, Excellentable will generate the outcome: