Manuals/calci/COLUMN

COLUMN (Array)

• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} is the cell of particular range of cells.
  • COLUMN(), returns the column number of a reference

Description

• This function gives the position of the column number for the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} .
• i.e COLUMN(B12)= 2 because Column number 2 is B
• When we are not giving the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} , it assumes the same cell where function COLUMN is displayed.
• If the reference argument is a range of cells, and if the COLUMN function is not entered as a horizontal array formula, the COLUMN function returns the number of the leftmost column.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} cannot indicate as a multiple sheets.

Examples

• COLUMN(F2) is 6, because F2 is in the position of 6th column.
• COLUMN() this will give the result where the function is displayed
• COLUMN(B1:F2) is 2, because it will give the result where the B1 is displayed.

Related Videos

COLUMN

See Also

• COLUMNS
• ROW

References

• Column

• List of Main Z Functions

• Z3 home