Formualizer Docs
ReferenceFunctionsLookup Functions

COLUMN

Returns the column number of a reference, or of the current cell when omitted.

Summary

COLUMN returns a 1-based column index (A = 1).

Remarks

  • With a range argument, COLUMN returns the first column in that reference.
  • Without arguments, it uses the column of the formula cell.
  • Full-row references such as 5:5 return 1.
  • Invalid references return an error (#REF!/#VALUE! depending on context).

Examples

Column of a single-cell reference
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
3
Column of a range
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
2

FAQ

What does COLUMN return for a range like B2:D4?

COLUMN returns the first column index of the reference (2 for column B).

What if COLUMN() is used without a reference?

It returns the formula cell's column number, or #VALUE! if current-cell context is unavailable.

Runtime metadata

Category

Lookup

Signature

COLUMN(arg1?: Range (Range))

Arity

min 0, max 1

Arguments

arg1optionalby-ref

Range · Range

Caps

PURE

Source

crates/formualizer-eval/src/builtins/lookup/reference_info.rs

Registration entry at crates/formualizer-eval/src/builtins/lookup/mod.rs.

CHOOSEROWS

CHOOSEROWS: Returns selected rows from an array or range.

COLUMNS

Returns the number of columns in a reference or array.

On this page

SummaryRemarksExamplesRelated functionsFAQWhat does COLUMN return for a range like B2:D4?What if COLUMN() is used without a reference?Runtime metadata