Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Lookup and Reference > COLUMN

 

COLUMN(reference)

 
 Returns the column number of the cell containing the function.

 referenceThe cell or range of cells which you want the column number for.

 REMARKS
 
  • This function can return an array.
     
  • The "reference" cannot refer to multiple areas ??
     
  • If "reference" is left blank, then the reference of the cell containing the function is used.
     
  • If "reference" is a range of cells, then the cell in the top left corner of the reference is used.
     
  • If "reference" is a range of cells referring to a horizontal array and the function is entered as a horizontal array formula using (Ctrl + Shift + Enter) then an array of column numbers is returned.
     
  • Row 4 has been entered as an array formula.

     EXAMPLES
     
     ABCD
    1=COLUMN() = 1=COLUMN() = 2510
    2=COLUMN(D1) = 4  20
    3=COLUMN(D1:D2) = 3   
    4{=COLUMN(C1:D1)} = 3{=COLUMN(C1:D1)} = 4  
     

     Functions - C | Index - C | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top