Spread Formula Reference
Formula Functions / Functions A to C / COLUMN
In This Topic
    COLUMN
    In This Topic

    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.

    See Also

    ROWS | INDEX | Lookup Functions