Difference between revisions of "Manuals/calci/COLUMN"

 
(10 intermediate revisions by 4 users not shown)
Line 1: Line 1:
<div style="font-size:30px">'''COLUMN(rf)'''</div><br/>
+
<div style="font-size:30px">'''COLUMN (Array)'''</div><br/>
 +
 
 +
*<math>Array</math> is the cell of particular range of cells.
 +
**COLUMN(), returns the column number of a reference
  
*'rf' is the cell of particular range of cells.
 
  
 
==Description==
 
==Description==
*This function gives the position of the column number for the 'rf'.i.e.
+
*This function gives the position of the column number for the <math>Array</math>.  
*COLUMN(B12)= 2 because Column number 2 is B
+
*i.e COLUMN(B12)= 2 because Column number 2 is B
*When we are not giving the 'rf', it is assumed to be the same cell where function COLUMN is dispalys.   
+
*When we are not giving the <math>Array</math>, 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.  
+
*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.  
*'rf'  cannot indicte as a multiple sheets.
+
*<math>Array</math> cannot indicate as a multiple sheets.
  
 
==Examples==
 
==Examples==
  
*COLUMN(F2) is 6 , because F2 is in the position of 6th column.
+
*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() 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.
 
*COLUMN(B1:F2) is 2, because it will give the result where the B1 is displayed.
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|4j0vJiYCHg4|280|center|COLUMN}}
  
 
==See Also==
 
==See Also==
 
 
*[[Manuals/calci/COLUMNS | COLUMNS]]
 
*[[Manuals/calci/COLUMNS | COLUMNS]]
 
*[[Manuals/calci/ROW | ROW]]
 
*[[Manuals/calci/ROW | ROW]]
  
 
==References==
 
==References==
[http://en.wikipedia.org/wiki/Complex_number| Complex Numbers]
+
*[http://www.techonthenet.com/excel/formulas/column.php Column]
 +
 
 +
 
 +
 
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 
 +
*[[ Z3 |   Z3 home ]]

Latest revision as of 17:11, 6 August 2018

COLUMN (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  .
  • i.e COLUMN(B12)= 2 because Column number 2 is B
  • When we are not giving the  , 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.
  •   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

References