Manuals/calci/ROW

ROW (Array)

• where $Array$ 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 $Array$ 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

• ROWS

References

• Row

• List of Main Z Functions

• Z3 home