ROW
Formulas / ROWIdentifies and returns the row number for a given reference
=ROW([reference])
- reference - [OPTIONAL] the cell or cell range for which the row number is returned
Examples
=ROW(C3)returns 3 which is the row number of C3. The ROW function returns the row number of the provided reference. This example references cell C3, which is the third row.
=ROW(A1)returns 1 which is the row number of A1. The ROW function considers the first row to be row 1.
=ROW(E3)returns 3 which is the row number of E3. This example references cell E3, which is the third row.
=ROW()returns the row number of the formula's cell. The ROW function returns the row number of the cell containing the ROW formula. This can be useful to identify the row number of cells containing calculations.
=ROW(E4:G6)returns {4,5,6} which is the row numbers of the range. The ROW function can also reference a range of cells. The function returns an array of row numbers in this case.
Need help with Formulas?
Summary
The ROW function is a useful tool for finding the row number of a given reference. It takes an optional argument, named reference, which is the cell or cell range to get the row number for.
- The ROW function returns the row number of a cell or range, when a reference is given.
- When no reference is given, the ROW function returns the row number of the cell containing the formula.
- The reference given may be a single cell or cell range, but must not include multiple references.
Frequently Asked Questions
What is the ROW function?
What is the reference argument of the ROW function?
What is the maximum number of areas the reference argument can reference?
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.