Returns the row number of a specified cell.
cell_reference– [ OPTIONAL – The cell in which the formula is entered by default ] – The cell whose row number will be returned.
cell_referenceis a range more than one cell wide and the formula is not used as an array formula, only the numeric value of the first row in cell_reference is returned.
ROWS: Returns the number of rows in a specified array or range.
COLUMNS: Returns the number of columns in a specified array or range.
COLUMN: Returns the column number of a specified cell, with 'A=1'.
Returns the row number of a cell reference.