< Go Back

Excel COLUMN Function

This function is categorized as a lookup/reference function. The Excel COLUMN function returns the column number for a reference cell. For example, COLUMN (B3), this formula returns 2, since B is the second column in the worksheet.

Syntax

=COLUMN([reference])

Argument

  • reference (optional)- It is a reference (column) to a cell or range of cells.

Note on the usage of a COLUMN function

Use a reference parameter to get column number of the reference.

  1. Reference parameter can be a single cell or array (range) of cells.
  2. The reference parameter is optional therefore when it is not defined then the function defaults to the cell in which the COLUMN function exists.
  3. Reference parameter must not include any multiple references or addresses

COLUMN function formula examples

  1. The Excel COLUMN function, when combined with other functions in Excel, can perform different unique operations. Some example includes
  2. To count rows with that contain specific values, to generate fixed value every N month, to count with repeating valued, to get address of a named range, to sum every nth column, to look up a value by matching across multiple column, to copy values from columns, to sum cell, to increment columns or rows, to get relative column numbers in range etc…

Example

The following example shows the usage of COLUMN function and the results returned by the function.

Figure 1. Shows the Excel COLUMN function used to return the column values

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar