Documentation/Calc Functions/COLUMN

From The Document Foundation Wiki
Jump to navigation Jump to search


Function name:

COLUMN

Category:

Spreadsheet

Summary:

Gives the column number of a cell reference. If the reference is a cell the column number of the cell is returned; if the parameter is a cell area, the corresponding column numbers are returned in a single-row array if the formula is entered as an array formula. If the COLUMN function with an area reference parameter is not used for an array formula, only the column number of the first cell within the area is determined.

Syntax:

COLUMN([Reference])

Returns:

Returns a positive whole number ranging from 1 to 1024 or a row array containing those numbers which is/are the column number(s) of a cell reference(s).

Arguments:

Reference is the reference to a cell or cell area whose first column number is to be found.

  • If no reference is entered, the column number of the cell in which the formula is entered is found. LibreOffice Calc automatically sets the reference to the current cell.

Additional details:

None

Examples:

Formula Description Returns
=COLUMN(A1) Column A is the first column in the table. 1
=COLUMN(C3:E3) Column C is the third column in the table. 3
=COLUMN(D3:G10) Here column D is the fourth column in the table and the COLUMN function is not used as an array formula. (In this case, the first value of the array is always used as the result.) 4
{=COLUMN(B2:B7)} or =COLUMN(B2:B7) Here both return the same result because the reference only contains column B as the second column in the table. Because single-column areas have only one column number, it does not make a difference whether or not the formula is used as an array formula. 2
=COLUMN() where this formula is entered in Column C By default current cell containing the formula is considered by the function. 3
{=COLUMN(Rabbit)} here the function is passed as an array function and "Rabbit" is the named area (C1:D3) The function returns a single-row array for the passed names area considering multiple columns since named area is used. (3, 4)

Related LibreOffice functions:

ROW

SHEET

ODF standard:

Section 6.13.4, part 2

Equivalent Excel functions:

COLUMN