In that case, you’ll want to use MIN to pull out just the first item.

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.

Excel formula: Last row number in range

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.

Excel formula: First column number in range

Excel formula: Last column number in range

Excel formula: Get relative row numbers in range

Excel ROW function

Excel MIN function