[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

COLUMN

Syntax:

COLUMN ( [ reference ] )

Description: Finds the number of the column(s) corresponding to reference.

Arguments:

Name

Type

Description

reference

reference

A reference to a single cell or to a range of contiguous cells. If omitted, the behavior is as if reference referred to the cell containing the formula.

 

Return Type and Value: number – If reference refers to a single cell or to a single column of cells, the corresponding column is returned. If reference refers to a range of cells involving multiple columns, a horizontal array of the corresponding columns as numbers is returned.

However, if the range of cells referred to by reference is not contiguous, #REF! is returned.

[Example:

COLUMN() results in 4, when the cell containing the formula is in column 4
COLUMN(E17:E19) results in 5
COLUMN(E16:F17) results in a horizontal array containing 5and 6, respectively

end example]