이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
ROW([reference])The ROW function returns the row number of a specified cell reference. If the reference argument is omitted, the function returns the row number of the cell where the formula is entered.
=ROW(A5)결과: 5
Returns the row number of cell A5.
=ROW()결과: 1
Returns the row number of the cell containing the formula (assuming it is in row 1).
If you provide a range, ROW returns the row number of the first cell in that range.