Difference between revisions of "Manuals/calci/COLUMN"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=...") |
|||
(16 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
− | <div | + | <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 | ||
− | |||
− | |||
− | |||
− | + | ==Description== | |
+ | *This function gives the position of the column number for the <math>Array</math>. | ||
+ | *i.e COLUMN(B12)= 2 because Column number 2 is B | ||
+ | *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. | ||
+ | *<math>Array</math> 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== | |
− | |||
− | |||
− | |||
− | |||
− | + | {{#ev:youtube|4j0vJiYCHg4|280|center|COLUMN}} | |
− | + | ==See Also== | |
+ | *[[Manuals/calci/COLUMNS | COLUMNS]] | ||
+ | *[[Manuals/calci/ROW | ROW]] | ||
− | + | ==References== | |
− | + | *[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
See Also
References