COLUMN
Definition of COLUMN
Returns the column number of a specified cell, with `A=1`.
Sample Usage
COLUMN(A9)
Syntax
COLUMN([cell_reference])
cell_reference
- [ OPTIONAL - By default, the cell containing the formula ] - The cell whose column number will be returned. ColumnA
corresponds to1
.- if
cell_reference
is a range more than one cell wide and the formula is not used as an array formula, the position of the first column incell_reference
is returned.
- if
See Also
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:
A
|
B
|
C
|
D
|
|
---|---|---|---|---|
1
|
||||
2
|
||||
3
|
||||
4
|
||||
5
|
||||
6
|
||||
7
|
||||
8
|
||||
9
|
||||
10
|
||||
11
|
||||
12
|
||||
13
|
||||
14
|
||||
15
|
E
|
F
|
|
---|---|---|
1
|