Difference between revisions of "Manuals/calci/ROW"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | |||
<div style="font-size:30px">'''ROW (Array) '''</div><br/> | <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>Array</math> is a cell or range of cells for which the row number is to be found. | ||
**ROW(), returns the row number of a reference. | **ROW(), returns the row number of a reference. | ||
Latest revision as of 16: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