Manuals/calci/COLUMNS

Revision as of 20:31, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left">  <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''COLUMNS'''</font></font></font><font color="...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
 

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