Difference between revisions of "Manuals/calci/ROW"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''ROW'''</font></font></font><font color="#484848"...") |
|||
| Line 1: | Line 1: | ||
| − | + | =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 == | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<div id="4SpaceContent" class="zcontent" align="left"> | <div id="4SpaceContent" class="zcontent" align="left"> | ||
{| id="TABLE2" class="SpreadSheet blue" | {| id="TABLE2" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | class=" " | | + | | class=" " | '''Function''' |
| − | | | + | | class=" " | '''ROW Output''' |
| − | + | ||
| − | | | ||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | | class=" " | | + | | class="sshl_f" | ROW(A6) |
| − | | class=" | + | | class="sshl_f" | 6 |
| − | + | ||
| − | |||
| − | |||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" | ROW(A4:C4) | |
| − | | class="sshl_f" | | + | | class="sshl_f" | 4 |
| − | + | ||
| − | |||
| − | |||
| − | | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| − | + | == See Also == | |
| − | + | ||
| + | *[[Manuals/calci/ROWS| ROWS]] | ||
| + | |||
| + | ==References== | ||
| + | |||
| + | *[http://en.wikipedia.org/wiki/Row_(database) Row] | ||
Revision as of 18:19, 11 December 2013
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.