|
<< Click to Display Table of Contents >> COLUMN (column number of cells) |
Syntax:
COLUMN([Reference])
Description:
This returns the column number(s) of a cell or cell range:
If Reference is a single cell, the column number of this cell is returned.
If Reference is a range of cells, their column numbers are returned as a horizontal array. Note: In this case, the formula has to be entered as an array formula (see Working with arrays).
If Reference is omitted, the column number of the cell that contains this function is returned.
Example:
COLUMN(D2) returns 4
COLUMN(D2:F4) returns {4,5,6}
COLUMN() returns 3 when you use this function in cell C5
See also: