Difference between revisions of "Manuals/calci/COLUMN"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''COLUMN( | + | <div style="font-size:30px">'''COLUMN(reference)'''</div><br/> |
| − | *<math> | + | *<math>reference</math> is the cell of particular range of cells. |
==Description== | ==Description== | ||
| − | *This function gives the position of the column number for the <math> | + | *This function gives the position of the column number for the <math>reference</math>. |
*i.e 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 <math> | + | *When we are not giving the <math>reference</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. | ||
| − | *<math> | + | *<math>reference</math> cannot indicate as a multiple sheets. |
==Examples== | ==Examples== | ||
| Line 17: | Line 17: | ||
==See Also== | ==See Also== | ||
| − | |||
*[[Manuals/calci/COLUMNS | COLUMNS]] | *[[Manuals/calci/COLUMNS | COLUMNS]] | ||
*[[Manuals/calci/ROW | ROW]] | *[[Manuals/calci/ROW | ROW]] | ||
==References== | ==References== | ||
Revision as of 02:59, 9 April 2014
COLUMN(reference)
- is the cell of particular range of cells.
is the cell of particular range of cells.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.