Manuals/calci/ROW

Revision as of 20:43, 24 October 2013 by MassBot1 (talk | contribs) (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"...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
 ROW(ref)

where ref is the cell or range of cells for which the row number is wanted.


 It gives the row number of a reference.

ROW


 

=ROW() gives the row number where it is placed

=ROW(B5) is 5




Syntax

Examples

Description

Column1 Column2 Column3 Column4
Row1
Row2 5
Row3
Row4
Row5
Row6