Manuals/calci/COLUMNS
COLUMNS(arr)
where arr is an array or a reference to a range of cells for which t the number of columns to be find.
I gives the number of columns in an [javascript:AppendPopup(this,'xldefArray_1') array] or reference.
COLUMNS
Let's see an example
= COLUMN(B2:E5) is 4.
Syntax
Examples
Description
Column1 | Column2 | Column3 | Column4 | |
Row1 | 8 | |||
Row2 | 4 | |||
Row3 | ||||
Row4 | 20 | |||
Row5 | ||||
Row6 |