Manuals/calci/ROW

Revision as of 18:19, 11 December 2013 by Swapna (talk | contribs)

ROW(reference)

  • where 'reference' is a cell or range of cells for which the row number is to be found.

ROW() displays the row number of a reference.

Description

ROW(reference)

For Example,

ROW(B5) returns 5.

  • The function gives the row number of a cell specified or the function where it is placed.
  • If reference is omitted, the function returns the row number of the cell where the function is written.

Examples

Function ROW Output
ROW(A6) 6
ROW(A4:C4) 4

See Also

References