ROW()
Syntax. ROW(reference)
Definition. This function returns the row number of a reference.
Arguments
reference (optional). Must evaluate to a reference to one cell or to a cell range.
Background. If you omit the reference argument, the function returns the row number corresponding to the cell containing the function.
If the reference is a cell range (name), you can use the function in array formulas. If the destination range includes fewer rows than the argument, the information in the missing cells is truncated. If the destination range is larger than the reference range, the excess cells display the #N/A error.
Examples. The following examples explain how to use the ROW() function.
Consecutive Numbers. If you want to create consecutive numbers starting ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
