Difference between revisions of "Manuals/calci/COLUMN"

From ZCubes Wiki
Jump to navigation Jump to search
 
(12 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 Bth column is displaying in the 2nd position.
+
*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/ROW | ROW]]
 +
 +
==References==
 +
*[http://www.techonthenet.com/excel/formulas/column.php Column]
 +
 +
  
−
*[[Manuals/calci/CHITEST | CHITEST]]
+
*[[Z_API_Functions | List of Main Z Functions]]
  
−
==References==
+
*[[ Z3 |   Z3 home ]]
−
[http://en.wikipedia.org/wiki/Complex_number| Complex Numbers]
 

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


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/COLUMN&oldid=210909"