ROW
Returns the row number of given cell reference or cell range. For ranges the top-left cell is used as pivot cell.
Syntax
=ROW([Cell or Range])
Arguments
| Name | Type | Description |
|---|---|---|
| Cell or Range (optional) | Range | Cell or cell range to get the row number for. If not given current cell is used |
Return
| Type | Description |
|---|---|
| Number | The row number. |
Examples
| Formula | Result | Comment |
|---|---|---|
| The row number of given range 1 |