Excel's ROW function returns the row number of a reference. The COLUMN function returns the column number. The examples in this tutorial show you how to use these ROW and COLUMN functions.
What do these ROW/COLUMN functions do in my Excel formulas?
The ROW function is used to:
The COLUMN function is used to:
In an Excel worksheet, rows are numbered from top to bottom, with row 1 being the first row. Columns are numbered from left to right, with column A being the first column.