Easy Explanation Notes with Examples

Excel ROW function

The ROW function returns the row number for a reference. For example, =ROW(B2) returns ‘2’ because B2 is the second row in the spreadsheet.

Syntax

ROW([reference])

Where [reference] is the optional argument. It is the cell reference or the range of cells for which you want row number.

If omitted, Excel returns ROW number of the cell containing formula.

Example

If [reference] provided is both a range of cells and a vertical array like (E6:F7), Excel will return the row number of the first cell in the range.

For more detailed information, visit Microsoft Official website.

Related Functions

COLUMN function returns the column number against the given cell reference.

COLUMNS function uses to find out the number of columns in a selected array or reference.

ROWS function returns the number of rows against a reference or array. For example, =ROWS(E5:E8) returns 4, because there 4 rows in the range.




Copyright © 2016 - 2019 Explainry.com | All Rights Reserved