returns row number of a reference · from excel · excel: not yet compared · sheets: not yet compared

signature

ROW([reference])

returns: number

argument	required
reference	optional

examples

formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.

related

• ADDRESS returns a cell address as text from row and column numbers
• AREAS returns the number of areas in a reference
• HLOOKUP searches first row and returns matching value
• HYPERLINK the text a link displays — clickability is the renderer's
• INDEX returns value at row and column in range
• INDIRECT returns reference specified by text string