COLUMN(reference) returns the column number of a reference : COLUMN « Lookup Reference functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Lookup Reference functions
  3. COLUMN
Input the formula: =COLUMN(A10). Press Enter to get the result.
Input the formula: =COLUMN(A10)








19.4.COLUMN
19.4.1.COLUMN(reference) returns the column number of a referenceCOLUMN(reference) returns the column number of a reference
19.4.2.=COLUMN() returns column in which the formula appears=COLUMN() returns column in which the formula appears
19.4.3.=COLUMN(D3)=COLUMN(D3)
19.4.4.=COLUMN(D3:G15)=COLUMN(D3:G15)
19.4.5.=COLUMN(Scores) return the first column of the Scores range=COLUMN(Scores) return the first column of the Scores range
19.4.6.COLUMNS returns the number of columns in an array or referenceCOLUMNS returns the number of columns in an array or reference
19.4.7.=COLUMNS({1,2,3;4,5,6}) returns the number of columns in the array constant=COLUMNS({1,2,3;4,5,6}) returns the number of columns in the array constant