COLUMN()
Syntax. COLUMN(reference)
Definition. This function returns the column number of a reference.
Arguments
reference (optional). Must evaluate to a cell reference or cell range
Background. If you omit the reference argument, the function returns the column number corresponding to the cell containing the function.
If the reference is a cell range (which can also be specified with a name), you can use the function in array formulas. If the destination range includes fewer columns than the argument, the information that would be in the missing cells is truncated. If the destination range is greater than range of the argument, the excess cells display the #N/A error.
Example. Assume that you want to add up the numbers in a row with even (or odd) column ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
