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.
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.
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.
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.