|
<< Click to Display Table of Contents >> COLUMN (column number of cells) |
Syntax:
COLUMN([Reference])
Description:
Returns the column number(s) of a cell or cell reference:
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 calculation in cell C5
See also: