These functions help work with positions and dimensions of ranges.

ROW

Returns the row number of a cell.

=ROW(A10)

Result:

10

COLUMN

Returns the column number.

=COLUMN(D1)

Result:

4

ROWS

Counts the number of rows in a range.

=ROWS(A2:A10)

Result:

9

COLUMNS

Counts the number of columns in a range.

=COLUMNS(A2:D10)

Result:

4

Real-World Uses

These functions are useful for:

  • Dynamic formulas
  • Numbering systems
  • Dynamic reports
  • Creating flexible lookup formulas
  • Working with large datasets

Practice

Create a worksheet showing:

  • Current row number
  • Current column number
  • Number of rows in a dataset
  • Number of columns in a dataset
PreviousNext