Formualizer Docs
ReferenceFunctionsLookup Functions

ROW

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

Summary

ROW returns a 1-based row index.

Remarks

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

Examples

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

FAQ

What does ROW return for a multi-cell reference?

ROW returns the first row index of the reference, not an array of every row number.

What if ROW() is called without arguments?

It uses the formula cell position; if no current cell context exists, it returns #VALUE!.

Runtime metadata

Category

Lookup

Signature

ROW(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.

RANDARRAY

RANDARRAY: Generates a random spilled array of numbers.

ROWS

Returns the number of rows in a reference or array.

On this page

SummaryRemarksExamplesRelated functionsFAQWhat does ROW return for a multi-cell reference?What if ROW() is called without arguments?Runtime metadata