Excel COLUMN function
- Example1: Obtain column number of a given cell reference
- Example2: Obtain column number which the formula is in
- Example3: Obtain the leftmost column number while reference is a range of cells
- Example4: Obtain the first cell of a data range
The COLUMN function returns the number of column which formula appears or returns the column number of given reference. For example, formula =COLUMN(BD) returns 56.
The COLUMN function returns a number representing the column.
Here I list some examples to show how to use the COLUMN function.
Supposing you have a defined name in a sheet which you want to obtain its first cell reference, the COLUMN function combined with the ROW and ADDRESS functions can help you.
ROW(Data)：row_num in the ADDRESS function, obtain the topmost row number of the name range of “Data”.
COLUMN(Data): column_num in the ADDRESS function, obtain the leftmost column number of the named range of “Data”.