For example, =ROW(C3) returns 3, since C3 is the third row in the spreadsheet.

When no reference is provided, ROW returns the row number of the cell which contains the formula.

When no reference is provided, ROW returns the row number of the cell which contains the formula.

Excel formula: Multiple matches into separate rows

COLUMN Function

The Excel COLUMN function returns the column number for a reference.

For example, COLUMN(C5) returns 3, since C is the third column in the spreadsheet.

When no reference is provided, COLUMN returns the column number of the cell which contains the formula.

Excel formula: Automatic row numbers in Table

COLUMNS Function

The Excel COLUMNS function returns the count of columns in a given reference.

Excel formula: Count with repeating values

Excel formula: Shade alternating groups of n rows

Excel formula: Get address of named range or table

Excel formula: Increment a calculation with ROW or COLUMN

Excel formula: Count unique text values in a range

Excel formula: Sum top n values

Excel formula: Automatic row numbers

Excel formula: Get relative row numbers in range

Excel formula: Address of first cell in range

Excel formula: Reverse a list or range

Excel formula: List sheet names with formula

Excel formula: Highlight every other row

Excel formula: Get work hours between dates custom schedule

Article image

Article image

Article image

Article image

Excel ROWS function

Excel COLUMN function

Excel COLUMNS function