Difference between revisions of "Manuals/calci/ROW"
Jump to navigation
Jump to search
| (6 intermediate revisions by 3 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 | + | **ROW(), returns the row number of a reference. |
| − | |||
| − | ROW() | ||
== Description == | == Description == | ||
| − | |||
ROW(reference) | 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 <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 | ||
| − | + | ROW() ''returns 7'' as a result. | |
| − | |||
| − | ROW( | ||
| − | |||
| − | |||
| − | |||
== Examples == | == Examples == | ||
| Line 21: | Line 17: | ||
{| id="TABLE2" class="SpreadSheet blue" | {| id="TABLE2" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | class=" " | | + | | class=" " | |
| − | | class=" " | | + | | ColumnA |
| + | | ColumnB | ||
| + | | ColumnC | ||
| + | | ColumnD | ||
| + | |- class="odd" | ||
| + | | class=" " | Row1 | ||
| + | | class="sshl_f " | 2 | ||
| + | | class=" " | | ||
| + | | class=" " | | ||
| + | | class=" " | | ||
| + | |- class="even" | ||
| + | | class=" " | Row2 | ||
| + | | class="sshl_f" | 5 | ||
| + | | class=" " | | ||
| + | | class=" " | | ||
| + | | class=" " | | ||
| + | |- class="odd" | ||
| + | | class=" " | Row3 | ||
| + | | class="sshl_f" | | ||
| + | | class=" " | | ||
| + | | class=" " | | ||
| + | | class=" " | | ||
| + | |- class="even" | ||
| + | | class=" " | Row4 | ||
| + | | class=" " | | ||
| + | | class=" " | | ||
| + | | class=" " | | ||
| + | | class=" " | | ||
| + | |- class="odd" | ||
| + | | class=" " | Row5 | ||
| + | | class=" " | | ||
| + | | class=" " | | ||
| + | | class=" " | | ||
| + | | class=" " | | ||
| + | |} | ||
| − | + | =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== | |
| − | |||
| − | |||
| − | |} | + | {{#ev:youtube|Vw7iNs-HRPk|280|center|ROW}} |
== See Also == | == See Also == | ||
| Line 41: | 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