Difference between revisions of "Manuals/calci/COLUMN"
Jump to navigation
Jump to search
| Line 4: | Line 4: | ||
==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 'rf'. |
| − | + | *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 'rf', it is assumed to be the same cell where function COLUMN is dispalys. | ||
| − | *If the reference argument is a range of cells, and if the COLUMN function is not entered as a horizontal array | + | *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 | + | *'rf' cannot indicate as a multiple sheets. |
==Examples== | ==Examples== | ||
Revision as of 00:34, 18 November 2013
COLUMN(rf)
- 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 'rf'.
- 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.
- 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 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.