COLUMN

COLUMN(reference)

Returns the column number of a cell reference.

reference

(Optional) The cell or range of cells which you want the column number for.

REMARKS

* This function can return multiple values.
* This function can create a Dynamic Array Formula.
* The "reference" can be a cell reference or a named range.
* The "reference" cannot refer to multiple areas.
* If "reference" is left blank, then the reference of the cell containing the function is used.
* If "reference" is a range of cells, then the cell in the top left corner of the reference is used.
* If "reference" is a range of cells referring to more than one column, then a dynamic array formula is returned.
* You can use the ADDRESS function to return the cell reference given a row and column number.
* You can use the COLUMNS function to return the number of columns in a cell range or reference.
* You can use the INDIRECT function to return the value of a given cell reference specified by a text string.
* You can use the ROW function to return the row number of a cell reference.
* You can use the ROWS function to return the number of rows in a cell range or reference.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A	B	C
1	=COLUMN() = 1	=COLUMN() = 2
2	=COLUMN(A1) = 1
3	=COLUMN(B1) = 2	5	10
4	=COLUMN(D1) = 4
5	=COLUMN(C1:D1) = { 3; 4 }
6	=COLUMN(C:C) = 1
7	=COLUMN(A:D) = { 1; 2; 3; 4 }
8	=COLUMN(INDIRECT("A:A")) = 1
9	=COLUMN(INDIRECT("A1:" & "C3")) = { 1; 2; 3 }
10	=COLUMN(INDIRECT("A9:B" & C3)) = { 1; 2 }

1 - What column number is this formula in.
2 - What column number is the cell range "B1".
3 - What column number is the cell range "D1".
4 - What column number is the cell range "D1:D2". This cell reference refers to a single column.
5 - What column number is the cell range "C1:D1". This cell reference spans two columns.
6 - What column numbers are in the columns "C:C".
7 - What column numbers are in the columns "A:D". This cell reference spans 4 columns.
8 - What column numbers are in the cell range "A:A".
9 - What column numbers are in the cell range "A1:C3". This cell reference spans 3 columns.
10 - What column numbers are in the cell range "A9:B10". This cell reference spans 2 columns.