- Formula Reference
- Contacting Us
- Getting Technical Support
- Formula Overview
-
Formula Functions
-
Functions A to C
- ABS
- ACCRINT
- ACCRINTM
- ACOS
- ACOSH
- ACOT
- ACOTH
- ADDRESS
- AGGREGATE
- AMORDEGRC
- AMORLINC
- ANCHORARRAY
- AND
- ARABIC
- AREAS
- AREASPARKLINE
- ARRAYTOTEXT
- ASC
- ASIN
- ASINH
- ATAN
- ATAN2
- ATANH
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BAHTTEXT
- BASE
- BESSELI
- BESSELJ
- BESSELK
- BESSELY
- BETA.DIST
- BETA.INV
- BETADIST
- BETAINV
- BIN2DEC
- BIN2HEX
- BIN2OCT
- BINOM.DIST
- BINOM.DIST.RANGE
- BINOM.INV
- BINOMDIST
- BITAND
- BITLSHIFT
- BITOR
- BITRSHIFT
- BITXOR
- BOXPLOTSPARKLINE
- BULLETSPARKLINE
- BYCOL
- BYROW
- CASCADESPARKLINE
- CEILING
- CEILING.MATH
- CEILING.PRECISE
- CELL
- CHAR
- CHIDIST
- CHIINV
- CHISQ.DIST
- CHISQ.DIST.RT
- CHISQ.INV
- CHISQ.INV.RT
- CHISQ.TEST
- CHITEST
- CHOOSE
- CHOOSECOLS
- CHOOSEROWS
- CLEAN
- CODE
- COLUMN
- COLUMNS
- COLUMNSPARKLINE
- COMBIN
- COMBINA
- COMPLEX
- CONCAT
- CONCATENATE
- CONFIDENCE
- CONFIDENCE.NORM
- CONFIDENCE.T
- CONVERT
- CORREL
- COS
- COSH
- COT
- COTH
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- COVAR
- COVARIANCE.P
- COVARIANCE.S
- CRITBINOM
- CSC
- CSCH
- CUMIPMT
- CUMPRINC
- Functions D to G
- Functions H to L
- Functions M to Q
- Functions R to S
- Functions T to Z
-
Functions A to C
COLUMN
This function returns the column number of a reference.
Syntax
COLUMN(reference)
Arguments
The argument is a cell or a single area.
Remarks
If the reference is omitted, the reference of the cell that the function is in is used.
Data Types
Accepts cell references. Returns numeric data.
Examples
COLUMN(A9) gives the result 1
COLUMN(A1:A5) gives the result 1
Version Available
This function is available in product version 3.0 or later.