Difference between revisions of "Manuals/calci/COLUMN"
Jump to navigation
Jump to search
| Line 5: | Line 5: | ||
==Description== | ==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. | *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(F2) is 6 , because F2 is in the position of 6th column. | ||
| Line 10: | Line 12: | ||
*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 05: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.