deepcalc
DocsROW

ROW

View as markdown/docs/functions/row.md Ask Claude about this pageOpens Claude with this page's address

Returns row number of a reference.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Number

Examples

=ROW()
Result 1
=ROW(B5)
B
5 10
Result 5

Syntax

ROW([reference])
reference
range optional
ADDRESSReturns a cell address as text from row and column numbers. AREASReturns the number of areas in a reference. HLOOKUPSearches first row and returns matching value. HYPERLINKThe text a link displays: clickability is the renderer's. INDEXReturns value at row and column in range. INDIRECTReturns reference specified by text string.