Difference between revisions of "Manuals/calci/ROW"
Jump to navigation
Jump to search
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | =ROW( | + | <div style="font-size:30px">'''ROW (Array) '''</div><br/> |
| − | + | *where <math>Array</math> is a cell or range of cells for which the row number is to be found. | |
| − | *where <math> | + | **ROW(), returns the row number of a reference. |
| − | |||
| − | ROW() | ||
== Description == | == Description == | ||
| − | |||
ROW(reference) | ROW(reference) | ||
| − | + | *For Example,ROW(B5) ''returns 5'' as a result. | |
| − | 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. | *The function gives the row number of a cell specified or the function where it is placed. | ||
| − | *If <math> | + | *If <math>Array</math> 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 | For Example, if the function is written in cell number 7, the function | ||
| Line 75: | Line 68: | ||
*[http://en.wikipedia.org/wiki/Row_(database) Row] | *[http://en.wikipedia.org/wiki/Row_(database) Row] | ||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 15:31, 9 August 2018
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.
is a cell or range of cells for which the row number is to be found.
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
See Also
References