Exceljet

Quick, clean, and to the point

Excel COLUMN Function

Excel COLUMN function
Summary 

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.

Purpose 
Get the column number of a reference.
Return value 
A number representing the column.
Syntax 
=COLUMN ([reference])
Arguments 
  • reference - [optional] A reference to a cell or range of cells.
Usage notes 

Use reference to get column number of a reference.

  • Reference can be a single cell address or a range of cells.
  • Reference is optional and will default to the cell in which the COLUMN function exists.
  • Reference cannot include multiple references or addresses.

Excel Formula Training

Formulas are the key to getting work done in Excel. In this accelerated video course, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn powerful skills to troubleshoot, trace errors, and fix problems. This is the formula training you should have had to begin with. See details here.

I found your video highly impressive and clear to understand for a foreigner as well! - Fazal
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course