Explanation
When given a single cell reference, theROW functionreturns the row number for that reference.
In that case, you’ll want to use the MIN or INDEX version above.
For example, ROW(C5) returns 5, since C5 is the fifth row in the spreadsheet.
When no reference is provided, ROW returns the row number of the cell which contains the formula.
ROWS Function
The Excel ROWS function returns the count of rows in a given reference.
MIN Function
The Excel MIN function returns the smallest numeric value in the data provided.
The MIN function ignores empty cells, the logical values TRUE and FALSE, and text values.
