Microsoft Office Tutorials and References
In Depth Information
COLUMN
Figure 9.1
The CHOOSE function
indexes values within
the formula to return an
exact result within a list.
1
Examples
1 through 7
A
Cell link
B
CHOOSE function index
Figure 9.2
The CHOOSE function
with form controls
creates an automated
indexing result based
on the cell link.
E
How forms
are built
D
IF statement
C
Nested IF
statement
COLUMN
Based on a given reference, COLUMN returns the column number.
=COLUMN(reference)
The COLUMN function returns the column number of a reference. For example, Column A = 1,
so cell A5 would equal 1.
This is the cell or range of cell for which you want the column number.
=COLUMN(A5) results in 1.
=COLUMN(B5) results in 2, and so on.
REFERENCE
Search JabSto ::




Custom Search