Tuesday 4 April 2017

excel - Microsoft Excel Column Function

Description

The Excel Column function returns the first column number within a supplied reference, or if no reference is supplied, the function returns the number of the current column in the currently active Excel spreadsheet. 

The syntax of the Column function is : 

COLUMN( [reference] ) 

Where [reference] is an optional argument that specifies the Excel reference that you want to return the column number of. If [reference] is omitted, the function returns the column number for the current cell (i.e. the cell that the function is entered into). 

Column Function Examples

The spreadsheets below show six examples of the Excel Column function. The spreadsheet on the left shows the formulas and the spreadsheet on the right shows the results: 


Note that the examples in cells A1-B2 of the above spreadsheet omit the [reference] argument. Therefore, the Excel Column function returns the column number of the cell that the function is entered into. 


No comments:

Post a Comment