Home
Microsoft Office Excel 2007 Tutorial
Introduction
Editing
Format Style
Table
Chart
Formula
Workbook Worksheet
Wordart Clip Art Shape Picture
PivotTable PivotChart
Data Analysis
Macro ActiveX Add in
Security
Collaboration
Database functions
Date Time functions
Engineering functions
Information functions
Logical functions
Lookup Reference functions
Math Trigonometry functions
Statistical functions
Text functions
ROW « Lookup Reference functions « Microsoft Office Excel 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Lookup Reference functions
ROW
19.13.ROW
19.13.1.
ROW(reference) returns the row number of a reference
19.13.2.
=ROW() returns the row number in which the formula appears
19.13.3.
=ROW(C4:D6) returns the first row in the reference
19.13.4.
ROWS(array) returns the number of rows in a reference
19.13.5.
=ROW(Scores) returns the first row of the Scores range