Detects functions that have several columns columns

First, Columns grammar

function function: Returns the number of arrays or references, in simple terms, the function can return the number of columns for the specified range or for the given data.

function Syntax:

COLUMNS (Array)

Parameter description

Array is the array or array formula for which you want to get the number of columns, or a reference to a range of cells.

Second, Columns function example

=columns (C1:E4) returns a value of 3, that is, the number of columns that refer to a range of cells is 3

=columns ({1,2,3;4,5,6}) returns the number of columns in an array constant 3

=columns (a:l) returns a value of 12, which is a column to L and a total of 12 columns.

=columns (B7) returns 1 because the B7 cell occupies only one column.

=columns (A5:B7) returns 2 because the number of columns A5:b7 occupies is 2.