Manuals/calci/ROW

From ZCubes Wiki
Jump to navigation Jump to search
ROW (Array)


  • where is a cell or range of cells for which the row number is to be found.
    • ROW(), returns the row number of a reference.

Description

ROW(reference)

  • For Example,ROW(B5) returns 5 as a result.
  • The function gives the row number of a cell specified or the function where it is placed.
  • If is omitted, the function returns the row number of the cell where the function is written.

For Example, if the function is written in cell number 7, the function

ROW() returns 7 as a result.

Examples

ColumnA ColumnB ColumnC ColumnD
Row1 2
Row2 5
Row3
Row4
Row5
=ROW(A3)   : Calculates the row number of cell A3. Returns 3 as a result.
=ROW(A4:C4): Calculates the row number in the range A4 to C4. Returns 4 as a result.

Related Videos

ROW

See Also

References