Difference between revisions of "Manuals/calci/COLUMN"
Jump to navigation
Jump to search
| Line 18: | Line 18: | ||
==See Also== | ==See Also== | ||
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/COLUMNS | COLUMNS]] |
| + | *[[Manuals/calci/ROW | ROW]] | ||
==References== | ==References== | ||
[http://en.wikipedia.org/wiki/Complex_number| Complex Numbers] | [http://en.wikipedia.org/wiki/Complex_number| Complex Numbers] | ||
Revision as of 06:32, 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.