Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

COLUMN

Find column number for a reference in Excel
Returns the column number of a reference

Rational

Find column number for a reference.

Description

The Excel COLUMN function returns the column number of a first reference cell. For example, =COLUMN(E10:F10) returns 5 (5th column same as the sequence of E in alphabets).

Syntax

=COLUMN([reference])

Parameters

reference [optional] – Reference cell to find the column number.

Return Value

An integer representing the column number of references.

Key Notes

  • The COLUMN function accepts empty, single cell or a range of cells as an argument.
  • Reference return the column number of the first cell in a range of cells. Moreover, it does not accept multiple areas.
  • If the reference argument is blank or empty, then the function returns the column number of that formula cell.

Keep Reading Similar Functions:

Return address of a cell in Excel

ADDRESS

The ADDRESS function returns cell address from given row and column numbers of a worksheet. For example, if you pass ADDRESS(5,6) the function returns $F$5.

Read More »
Count of rows in a cell range in Excel

ROWS

The ROWS function returns the number of rows of a cell range or array formula, =ROWS(E10:F100) returns 91 (91 rows in the cell range i.e. 10 to 100).

Read More »
Find ROW number of a reference in Excel

ROW

The ROW function returns the row number of a reference cell. For example, =ROW(E9:E10) returns 9 (9th from top to bottom, only the first cell).

Read More »
Find number of areas in reference in Excel

AREAS

The AREAS function returns a number of areas or region. I.e., =AREAS((B2:C4,D8:F9)) returns 2 (number of areas), include extra sets of parentheses.

Read More »
Count all columns of a cell range in Excel

COLUMNS

The COLUMNS function returns a count of all columns of a cell range or array formula, =COLUMNS(E10:F100) returns 2 (two columns E & F).

Read More »