COLUMNS function

COLUMNS returns the column number of a cell reference.

Syntax

If the reference is a cell, the column number of the cell is returned.

COLUMNS(array)

array is the reference to a cell or cell area whose first column number is to be found.

Example

=COLUMNS(B5) returns 1 because a cell only contains one column.

=COLUMNS(A1:C5) equals 3. The reference comprises three columns.




Trademarks | IBM Connections wiki