writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − <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"><font face="Arial, sans-serif"><font size="2">(ref)</font></font></font>+ − <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''where ref '''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">is the cell or range of cells for which the row number is wanted.</font></font></font>+ − </div>+ − ---- − <div id="1SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">It gives the row number of a reference.</font></font></font></div> − ---- − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> − ROW+ − </div></div>+ − ---- − <div id="8SpaceContent" class="zcontent" align="left"> − <font color="#484848"><font face="Arial, sans-serif"><font size="2"><nowiki>=ROW() gives the row number where it is placed</nowiki></font></font></font>+ − <font color="#484848"><font face="Arial, sans-serif"><font size="2"><nowiki>=ROW(B5) is 5</nowiki></font></font></font>+ − <br /><br />+ + − </div>+ − ---- − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div> − ---- − <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div> − ---- − <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div> − ---- − + − + − | Column2+ − − | Column4 − + − + − | class=" " |+ − | class=" " | − | class=" " | − | class=" " | Row2+ − + − | class=" " |+ − | class=" " | − | class=" " | − − | Row3 − | class=" sshl_f " | − | class=" " | − | class=" " | − | class=" " | − |- class="even" − | Row4 − | class=" " | − | class=" " | − | class=" " | − | class=" SelectTD SelectTD" | − <div id="4Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="4Space_Copy" title="Click and Drag over to AutoFill other cells."></div> − |- class="odd" − | class=" " | Row5 − | class=" " | − | class=" " | − | class=" " | − | class=" " | − |- class="even" − | Row6 − | class=" " | − | class=" " | − | class=" " | − | class=" " | − <div align="left">[[Image:calci1.gif]]</div></div>+ − ----+ + + + + +
no edit summary
=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'''
| Column1
| class=" " | '''ROW Output'''
| Column3
|- class="odd"
|- class="odd"
| class=" " | Row1
| class="sshl_f" | ROW(A6)
| class=" sshl_f " |
| class="sshl_f" | 6
|- class="even"
|- class="even"
| class="sshl_f" | ROW(A4:C4)
| class="sshl_f" | 5
| class="sshl_f" | 4
|- class="odd"
|}
|}
== See Also ==
*[[Manuals/calci/ROWS| ROWS]]
==References==
*[http://en.wikipedia.org/wiki/Row_(database) Row]