Difference between revisions of "Manuals/calci/COLUMN"
Jump to navigation
Jump to search
| Line 11: | Line 11: | ||
*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. | ||
| − | |||
==See Also== | ==See Also== | ||
Revision as of 06:28, 12 November 2013
COLUMN(rf)
- 'rf' 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 Bth column is displaying in the 2nd position.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 indicte 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.